Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Maybe this on the listbox name (calculated dimension):
=aggr(only({<name=P(name)>}name),name)
Hope it helps,
YB
May be try this
Aggr(Only({1<school = p(school)>} name), name)
Check the attached sample also