I am trying to build a dashboard that allows managers to compare the performance of one level of a hierarchy against another level("Region to System" or "Store to Region").
The attached workbook works, but I don't think it is completely intuitive to the end user and requires a lot of clicks. I also don't think it will work well with 500 stores and 10 regions.
In the attached, there are 3 different parameters for each line.
Ideally, I would like the second parameter option to change based on the first.
I don't think there is a way to accomplish this with parameters or filters, so I'm looking for other suggested alternatives to compare between the hierarchical levels for a large number of regions and stores.
Thanks - Randy