Displaying totals of calculated fields in Pivot tables/charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MG - 12 Apr 2004 06:38 GMT

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 ?

Reply to this Message

Dave Peterson - 12 Apr 2004 22:44 GMT

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.)

> 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 ?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message