Thread: PIVOT TABLES
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Chamara Chamara is offline
external usenet poster
 
Posts: 1
Default 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.