2 Replies Latest reply: Feb 15, 2017 11:55 AM by Sunny Talwar RSS

    Hide Greyed out Values in Filter Boxes

    Priyash shahane

      Hello Guys,

       

      I have 4 filter boxes in one sheet. What I want is to hide the greyed out values totally based on selection in previous filter box

       

      For example

       

      Current Scenario:

      The Filter Value selected by User is depicted in BOLD

      Filter1   Filter 2

      A          1( Visible with white background)

      B          2 (Visible with white background)

      C          3 (Greyed out since option not available for Filter1 selection A)

      D          4 (Greyed out since option not available for Filter1 selection A)

       

       

      Output Wanted:

       

      Filter1   Filter 2

      A          1( Visible with white background)

      B          2 (Visible with white background)

      C         

      D         

       

      I read through the forum however did not understand how AGGR function is exactly used in this scenario.

      Could someone please help me with the solution.

       

       

      Thank.

       

       

      Best,

      Priyash