filter the values in a page selector based on another page selector
I have 2 separate hierarchies
1. L1 Region L2 Country
2. L1 Channel L2 Retailer
I have a planning module that uses both these dimensions and to plan for units sold in a country at a retailer.
I have published both the lists as page selectors on a dashboard. Currently when a user selects a country and then select a retailer they cannot see which retailers are in a specific country.
If I want to provide that functionality will I have to create a new hierarchy or is there another way to