Multi Dimensional Subtotals for Grand Totals in Pivot Table

[Eduard10]

For Sales Analysis, I use large pivot tables, based on transactional data. I want to be able to analyze everything in three dimensions:
1. Product: Product Group, Subgroup, Product
2. Geographical: Global, Continents, Countries
3. Time: Year, Quarter, Month

I currently use the following set up in my pivot tables:
Row labels: 1. Product Group, 2. Sub Product Group, 3. Product
Column labels: 1. Chosen Geographical level 2. Year, 3. Quarter, 4. Month
Values: sum of units

The problem is that for every different geographical level (e.g. instead of all global numbers, I want to see all continents), I need to use a different pivot table, which significantly increases the size of my workbook. Ideally, I would like to use everything in one pivot table, but it seems impossible, since I can only get grand totals, and not subtotals.

Hope someone can help me. Thnx!

 

[oldbrewer]

can you move to a database ?

 

[Maverick27]

Which version of MS Office are you using ?

MS Office Excel 2013 PowerPivot has the new Timeline & Geographical "Slicer" Feature.

Youtube Tutorial

The new Power BI Tools (PowerView, PowerPivot, PowerChart) only works with Office 2013 Pro Plus & 365

 

[Eduard10]

Which version of MS Office are you using ?

MS Office Excel 2013 PowerPivot has the new Timeline & Geographical "Slicer" Feature.

Youtube Tutorial

The new Power BI Tools (PowerView, PowerPivot, PowerChart) only works with Office 2013 Pro Plus & 365

Thanks for your reply!
Unfortunately I am using Excel 2007. Upgraded to Excel 2010 recently, but it couldn't handle large files, so I was temporarily rolled back to Excel 2007 again.