pivot table confusion

Giganews Newsgroups
Subject: pivot table confusion
Posted by:  rogbot (anonymo…@discussions.microsoft.com)
Date: Mon, 20 Oct 2003

Trying to do lots of slicing and dicing on results for
customer project with data that is in form of percentages,
then showing averages for location, activity, etc

Works great when use show field as Normal, but when use
Difference From or % Difference From, get the #NA error
message.  Ive checked to eliminate all blank values, and
am getting error message even where there I have validated
that value is not 0.

Any suggestions?

Replies