| 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 | |||
Linear Mode
