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