Dynamic Listboxes

[#1]

Hi all,

How can I dynamically update the Country listbox to show only the countries related to the Region? So for example, when I select 'South East Asia' in Region, I only want it to to show 'India, Indonesia, Malaysia, Phillipines, Singapre, Thailand and Vietnam. Likewise, if I select 'Pacific' in Region, it will only show New Zealand and Australia.

[Anonymous]

Under properties in the general tab click on 'Hide Excluded'

[sasikanth]

hi

Please find the Attached File

[jonathandienst]

Hi

You can use an expression like this in your listbox:

=Aggr(Only(Country), Country)

Or

=Aggr(Only({<Country=>} Country), Country) (which should not collapse to a single country if you select one)

HTH

Jonathan

Edit: fixed second expression (missing <, >)

[#5]

Many thanks, worked!