4 Replies Latest reply: Mar 8, 2018 9:39 AM by Ellen Yama RSS

    Advanced filtering that stays on top level

    Ellen Yama



      I would like to be able to filter my data where the filter is a drill down, but only data for the particular filter will be displayed.


      For example, I have a drill down with two layers and every layer option below has its own data.


      Layer 1 : Finance

      Layer 2a: Managers

      Layer 2b: Professionals


      Currently, if I select Finance in the filter, it will show me data for Finance, Managers, and Professionals. I want it to only show me data for Finance and exclude data for Managers and Professionals. (This is assuming that even finance has its only data independent of managers and professionals). I do not want to have the user select FInance again as Layer 2c.


      Any help would be appreciated. Thank you.