ExcelBanter - pivot table grand total

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivot table grand total (https://www.excelbanter.com/excel-discussion-misc-queries/207216-pivot-table-grand-total.html)

pivot table grand total

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

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