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.
I essentially want a table output with just a filter. Below is the raw data. I'd like to have some sort of filter where if I select Finance, it will only show me the top two rows below. I would then have the option though to select Manager and Professional (like a drill down filter) and if I select Manager, it will only show me the third row of data below. Currently, if I select Finance, it will show me all four rows.
As a note, I need to keep the hierarchy to some extent so that the user can keep clicking down through the layers to get to the layer they need.