Pivot Table Presenting Data

Hi Guys,

I've been working on a project that is giving me headaches and I'm hoping you're able to help me out. I've been looking through this forum and other fora for a while now and there is no clear solution and I'd definitely appreciate your help. So here is the thing:

I've been asked to work out a way to easily present summarized data which, when so desired, should be able to go into deeper detail. The only way I know how to do this is via Pivot Table. The thing is, that simply adding the numbers doesn't make sense at all. The reason is that I'm working in share of market per country and simply averaging these shares doesn't make sense due to different market sizes in terms of absolute volumes. Hence different weights need to be given to each share. Allow me to illustrate: I'm interested in Belgium, the Netherlands & Luxembourg and their combined area, the BeNeLux. Each country sells products A - C. Adding the numbers per country is fine as that total amounts to the total company share for that country, but for the area it doesn't. So what I want to do is show the data as follows (see also attached screenshot):

BeNeLux
--------> Belgium
-----------------> Product A
-----------------> Product B
-----------------> Product C
--------> Netherlands
--------> Luxembourg

I want each click to go into further detail, but initially it would show only BeNeLux - only after clicking it would show each country separately and if needed, the products after another click. I have all the numbers such as share for the area but I can't seem to get it to show the right way.

Any help would be greatly appreciated.

Thanks in advance,
Stuart

ExcelHelp.jpgExcelHelp.xlsx