Is it possible to create dependent page selectors when more than one list is published as a page selector?
I have a module that forecasts demand for SKUS in different country.
Currently when the user selects the country the next selection is SKU but the SKU dropdown shows SKUs for all countries. I created a filer module for Country and SKU and I am using the filter to show SKUs by country.
This seems to work then my SKUs are in rows but not when I pivot the SKU dimension to page selectors.
Is it possible to have one page selector (list) filtered based on another page selector(list)?
Yes and no....Yes it would be a new hierarchy, but if you do it correctly where the code is a concatenation of the Country code and SKU code (100_100987) then you can use this for reporting but still be able to get back to the SKU Flat list (because it is part of the code) as well as the Country. Plus, your module will be much smaller in size because not every SKU (I am assuming) will go to every Country. This way, it actually opens you up to more possibilities. If your SKU does span multiple Countries, then make that a numbered list and have the display name be list formatted back to the SKU Flat list. That way, if the SKU ever changes, it will automatically be updated in this list. Lastly, if you the requirement that only certain folks can see certain Countries as well as SKU's, then you can put selective access on this new list.
Alternatively, you could create a "SKU selector" module, which is synchronised, or filtered based on the country. This could then by published to the side or top of the dashboard and then used to synchronise the bottom grid