3 Replies Latest reply on Jan 17, 2018 4:05 PM by Shinichiro Murakami

    Is there an action filter that will simultaneously drill down on a hierarchy when clicked?

    Christopher Wen

      Say I've got a table:

       

       

       

      Hierarchy 1 Metric
      Sports130
      Music120
      Total250

       

      If I click the , it will expand to the below.

       

      Hierarchy 1 Hierarchy 2 (Originally Hidden) Metric
      SportsFootball50
      Dodgeball20
      Soccer60
      Total130
      MusicViolin100
      Cello10
      Saxophone10
      Total120

       

       

      Question:

       

      Is there an action filter I can produce such that if in Table 1 above, I click "Sports", it will automatically filter for ONLY "Sports", AND it will expand the Hierarchy to Hierarchy 2 (yielding table 3 below):

       

      Hierarchy 1 Hierarchy 2 (Originally Hidden) Metric
      SportsFootball50
      Dodgeball20
      Soccer60
      Total130