1 Reply Latest reply on Jul 12, 2018 3:57 AM by kumar bharat

    automatic hierarchy drill down  by selecting filters

    Patrick Weber

      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.