Possible to hide pivot filter options that produce blanks

[Sniklfritz]

Hello all,

My issue is a minor annoyance more than anything. I have a pivot that I filter by 3 different hierarchies that have many options in each and can go down to 4 levels and deal with medical injury cases.

What I am wondering if it is possible is if I make a selection on one of the filter hierarchies it can remove options that dont exist in the other filters to save me from having to "guess".

Regards,
S

 

[BSALV]

Did you ever use slicers ? I think that's your answer.

 

[Sniklfritz]

Did you ever use slicers ? I think that's your answer.

I have, but is there an elegant way to use them when the hierarchies could each have 50-100 choice combinations?
E.G. L1 of the hierarchy could have 8 options then L2 could have 8-12 each then same for L3 and L4.

So an example choice might be L1 Hazardous Substances -> L2 Chemicals -> L3 Flammable Chemicals -> L4 Petroleum.

And I may need to filter by injuries caused by "Chemicals" or I may want to know just "Flammable Chemicals"

Then after I choose I may want to know what types of injuries happened from flammable Chemicals but the 2nd hierarchy doesn't currently filter out null values... so I need to click through alot of the tree to figure out myself...

S