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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate grand total 2
Pivot table grand total location 1
Summing for every change in a pivot table 1
Macro to add numbers in a text string 5
Pivot Table Grand Total Plus Calc Field or GT Running Balance 6
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table Calculates the Difference in Grand Total 2
calculating variances in pivot tables 3

Top