2 Replies Latest reply on Sep 14, 2016 11:04 PM by Zi Xiang Kao

    Restricting filter options based on another filter

    Zi Xiang Kao

      Hello everyone,

       

      I am aware a similar question has been answered before but my use case is rather different. Anyway, here goes:

       

      I have a table with 2 fields, A and B. For each of these fields, I have created a quick filter (filters A and B). The table looks like:

       

      A
      B
      A1B1
      A2B2
      A3B3

       

      When I set filter A to A1 and A3, the table now looks like:

       

      A
      B
      A1B1
      A3B3

       

      Is it possible for filter B to only show options B1 and B3 when the above happens? (selecting 'only relevant values' doesn't help)

       

      Cheers,

      Zi Xiang