Filter by list hierarchy in the dashboard
I have difficulties to filter the tables in dashboard or in the modules.
For example in the screenshot (see attachment) :
I selected two lists: stores as columns, and products as rows. The parent level of stores is Regions (West, East, etc.) and the parent of products is Categories (Category 1, 2, 3).
And I set 2 page selectors in a dashboard: one is Regions and the other is Categories. And I would like to show only the rows and columns which match with theses two selectors: For instance, I would like only to see (p1, p2, p3, category 1) x (w1,w2, w3, West) of the table if I select (Category1, West).
Does anyone have any propositions to get these lists "filtered" ?
Thanks a lot!