Hide Greyed out Values in Filter Boxes

[Anonymous]

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

[Anonymous · Accepted solution]

Stupid Mistake on My End

The Answer to this is simple: In the 2nd filter box: the Field entry should be Aggr(Filter2,Filter2) instead of simply Filter2

[sunny_talwar]

May be try this:

=Aggr(Only({1<Filter1 $::Filter1>}Filter2), Filter2)

or

=Aggr(Filter2, Filter2)