Button Action

[kulasekhar]

hhh

[Nicole-Smith]

All you're missing is a {1} in your set analysis (this will tell it to ignore selections that are already made).

So for Perf:

='('&Concat({1}Distinct MD2,'|')&')'

And for Prog:

='('&Concat({1}Distinct MD1,'|')&')'

I've also attached your example but I've fixed it.

I hope this helps!

[petter]

Just add the set expression {1} to your Concat()-function in each of the Actions for each button:

='('&Concat( {1} Distinct MD2,'|')&')'

and

='('&Concat( {1} Distinct MD1,'|')&')'

[petter]

funny that I should post only seconds after Nicole ...