Hiding excluded values

[#1]

Hi, I have two listboxes, name and school. I selected a value in school so now there are only a few possible values in name, I want the greyed out values not to show up, but I do not want to use the hide excluded feature because when I click on a certain name, I still want the other names under that school to be present. Is this possible in anyway?

Thanks,

Natasha

[YoussefBelloum]

Hi,

Maybe this on the listbox name (calculated dimension):

=aggr(only({<name=P(name)>}name),name)

Hope it helps,

YB

[sunny_talwar · Accepted solution]

May be try this

Aggr(Only({1<school = p(school)>} name), name)

[sunny_talwar]

Check the attached sample also