M
Mr. Low
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
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