Hi,

I want to show sales by Region  -> Country -> State -> City. In dashboard, there is a worksheet that shows sales by Regions ( which has hierarchy). Sales by America, Asia, etc. When I click on America it should drill down to Country worksheet and Region worksheet should hide. Also, if it's hierarchy, is it possible to show hierarchy on the top of the dashboard and user can click back on region or any element in the hierarchy and corresponding worksheets appear but still the hierarchy is there on the top of the dashboard.

if anyone has solution to this, it will be helpful if you could share the workbook.

Thank you