Is there a way if in a hierarchy if a dimension is selected by a filter that the hierarchy will drill down automatically?
In my attached workbook I'm using the data of superstore example.
E.g. in the filter Manufacturer 'Acme' will be selected then it's expected that the view will show all information down to level 4 (Product Name)
or if in "sub-category" copiers is selected everything will be drill down to Manufacturer.
Is there a way to create a logic with calculation? I know it's possible with date hierarchy but don't know if there is a similar logic for normal hierarchy.
Thanks for any hints.
Please check this: