Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a List box that filters its displayed values based on selection within another list box. The two list boxes are Divisions and Metrics. When I select any given Division, I want that divisions metrics to display within the Metrics box. However, I am having trouble hiding those that are not selected.
I go to the Metrics listbox, and on the General tab I select <expression> as the field type, within which I write:
=GetCurrentSelections(Divisions), which on returns, when selected, Divisions: (Selection Made), ex: Divisions: Finance.
Any and all help is appreciated. Thanks.
or
=Aggr(Only({$<Metrics=>}Metrics), Metrics)
if you want to keep the division metrics visible even with metric selections.
hope this helps
regards
Marco
Hi,
one solution could be:
=Aggr(Metrics, Metrics)
hope this helps
regards
Marco
or
=Aggr(Only({$<Metrics=>}Metrics), Metrics)
if you want to keep the division metrics visible even with metric selections.
hope this helps
regards
Marco
Try a drill-down group: Division -> Metrics
Thank you all for the fast reply. That was exactly what I was looking for!
nice that it worked.
please select a correct answer.
thanks
regards
Marco