| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating difference on Pivot Table Totals
I have a pivot Table as follows
Region State jan Feb ... Columm North NY 1 5 NJ 5 1 North Total 6 6 South FL 2 6 GA 6 2 South Total 8 8 Grand Total 14 14 I would like to change the display of Grand total to show the difference between the region as follows Grand total difference (2) (2) Any help on this is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| Incorrect totals in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Subtotals - Difference | Excel Worksheet Functions | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
Linear Mode
