pivot table confusion

  • Thread starter Thread starter rogbot
  • Start date Start date
R

rogbot

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?
 
I do not really understand your exact problem, but I think you have
discovered what I have too - that it is a complete waste of time
trying to get more from pivot tables than they were really designed to
do. I now only use them as a simple link between raw data and
worksheet output.

Having come to this, it still does not reduce their tremendous value
in organising data quickly and efficiently. As someone who did not
have this functionality years ago I can testify to this.

All tools have their uses and limitations.

Regards
BrianB
=======================================
 
Back
Top