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
|