intersection of possible field values across alternate states

[#1]

I would like to create a delimited list of the intersection of possible values from the same field in alternate states to use in a Toggle Select Action?

If I have concat({[Group 1]} NAME, '|') = Bob|Tom|Harry

and concat({[Group 2]} NAME, '|') = Bob|Nick|Mike|Tom

I need Bob|Tom for my Toggle Select.

Help much appreciated.

Thanks!

[lironbaram · Accepted solution]

hi

use

=

Concat({Group1*Group2}Distinct NAME,'|')

[#3]

Thank you!