9 Replies Latest reply on Sep 4, 2018 6:25 AM by Shinichiro Murakami

    Filtering Hierarchy


      Hi All,


      I've created a sheet that places an X on a line graph to show where an individuals test score falls on a range. The individual can be in one of four categories: Male, VMF; Male, Non-VMF; Female, VMF; or Female, Non-VMF. Each of these categories has its own range. As of now when I select an ID number I have to manually set the Gender filter and the VMF filter in order to see the X on the appropriate range.


      Is there a way to set a hierarchy of some sort so that when I select an ID the Gender and VMF filters automatically update to the correct selections? I have been messing around with context filters and "Only relevant values" selections but I haven't been able to get it to work properly. Any insight would be appreciated!