3 Replies Latest reply on Apr 19, 2018 3:25 PM by Hari Ankem

    Quick Filter - Only relevant value

    jiayi zhang

      Hi,

       

      I have two quick filters with Filter 2 only show relevant values.

      My data looks like this:

      By default, I'd like to display 'B' in Filter 1 and 'b' in Filter 2.

      When I switched value  in Filter 1 to 'A', I would like to display 'a' without manually changing the filter or showing the value as (b) like following:

       

      Does anyone know if it is possible or have an alternative solution?

      Thank you!

      Jiayi