Displaying totals of calculated fields in Pivot tables/charts

  • Thread starter Thread starter MG
  • Start date Start date
M

MG

I find that, when I create a Pivot table, I can only derive totals for
those items that have been entered by hand - wnen I try to get totals
of calculated fields, I only get the count of occurrences of those
fields
Any ideas ?
 
It sounds like your calculation columns may be returning something besides
numbers.

If you have formulas that look like:

=if(something's_true,"",a1*3+5)

Then that string value ("") will make it so that the pivottable wizard will
default to count.

Just double click on that "button" in the Data Area (when you're in the Wizard)
and you can change it to Sum/Average/min/max and lots more.

You could also adjust your formula to return a numeric value:

=if(something's_true,0,a1*3+5)

(But that might mess up the appearance of the original data source.)
 
Back
Top