pivot table grand total
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...
--
HTH...
Jim Thomlinson
"Kardal" wrote:
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
|