ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   PIVOT TABLES (https://www.excelbanter.com/setting-up-configuration-excel/256625-pivot-tables.html)

Chamara

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.


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com