PIVOT TABLES
I need to put 2 selections in a pivot table under 'values' (Office 2007). But
One selections should show all the details. Other one should ONLY show the
TOTALS at the end of the pivot table.
Ex:
Product Month - Export (Pcs) Month - Export (Pcs) Total
Account Tot
JAN FEB MAR
Tea 20 30 40 90
30USD
Rubber 10 10 20 40
40USD
Coconut 50 30 10 90
20USD
As shown above, I need to only PUT the Account Total at the end but NOT in
detail level.
|