Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
Pivot Table (Grand Total) | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
Grand total in Pivot-Table | Excel Worksheet Functions |