Creating a Dynamic Listbox

[#1]

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.

[MarcoWedel]

Hi,

one solution could be:

=Aggr(Metrics, Metrics)

hope this helps

regards

Marco

[MarcoWedel · Accepted solution]

or

=Aggr(Only({$<Metrics=>}Metrics), Metrics)

if you want to keep the division metrics visible even with metric selections.

hope this helps

regards

Marco

[Anonymous]

Try a drill-down group:  Division -> Metrics

[#5]

Thank you all for the fast reply. That was exactly what I was looking for!

[MarcoWedel]

nice that it worked.

please select a correct answer.

thanks

regards

Marco