Can I create a list box or other object that lists all excluded values in a dimension?
I want to create a functionality where the user selects a [Company], and a list box shows all related [Orders]. Then, when he selects some orders, the other excluded orders will appear in a second list box. Ideally, the user would then be able to add some of the excluded orders back into the selection, and have the list update.
Any guesses? Thanks.
Sure Andy, although not sure if it will be helpful.
In this app, I have selected Company 'A'. I then have Contracts 'v' and 'w' available to select.
If I select 'v', I would like contract 'w' (the excluded value within set Company='A), to be listed separately somewhere.
Ideally in addition, the user could then select 'w' again to have it returned to the selection.
Awesome, awesome, thank you all! All your responses were correct, but I gave the correct answer to Massimo, because his solution very cleverly only shows those selections excluded within Company 'A'.