pivot table grand total

K

Kardal

I have 3 columns
Units Cost Total
5 5 25
10 10 100
tot 15 15 225
Col3 Total is a calculated fiels and i want to know how can i get the grand
total col 3 to equal the sum of col 3 items of 125
Thanks
 
J

Jim Thomlinson

That needs to be calculated outside of the pivot table. Pivot tables do not
support 2 pass calc's. First calcuate the Extended amount and then add up the
extended values...

2 choices. One is to do the calcl in the source data (usually the best
option). The other is to calculate against the pivot table results...
 
Top