Drill down chart with Different measure for each dimension

Hi All,

I want to create a drill down Dashbaord (Region > Division > Country > State).

I have all the fields in the dataset.

Also,, want I want is to display different measure for each dimension that I select.

For example -

When I am at the Region Hierarchy I want to see the bar chart in the dashbaord for the Regions selected

showing

> number of stores

> number of divisions

> Disount average

At the Division level - for the division selected I want to see the bar chart showing the below dimensions -

> number of Countries in selected Division

> number of Cities

> average profit

and so on for the other items in the hierarchy.

I have attached a workbook with sample data.

Would like to know the approach for creating such a dashbaord. Any examples would be really useful, thank you.

Thank you!

Regards,

Rishi Saka