Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 Pivot Table: How to modify sub and grand totals ?
Dear Sir,
By default the pivot table I generated look like this: Year Year Total Area Account Document 2006 2007 UK M241 Invoice 260 840 1100 CN -20 -40 -60 M241 Total 240 800 1040 ------------------------------------------------------------------ R476 Invoice 500 600 xxx CN -50 -20 xxx R476 Total 450 580 xxx ----------------------------------------------------------------- UK Total 690 1380 xxx ===================================== US T960 Invoice xxx xxx xxx CN ====================================== Grand Total 5250 6320 11,570 ====================================== Can I modify the Areal and Grand Total to : Invoice xxx xxx xxx CN xxx xxx xxx Area Total xxx xxx xxx ----------------------------------------------------- Invoice xxx xxx xx CN xxx xxx xxx Grand Total xxx xxx xxx ============================== i.e. Invoices and CN ttal in each account add up to area total and area total add up to grand total with the respective document breakdown. Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Pivot Table : Can I edit and modify it ? | Excel Discussion (Misc queries) | |||
Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals - Hide Some, Not All | Excel Discussion (Misc queries) | |||
Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) | |||
Pivot Table Grand Totals | Excel Worksheet Functions |