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