Associated data to be selected in list box

[Anonymous]

Hi, I am using member Id is the key to represent the data in dashboard. But now, I want to show accounts associated to  emailID in a object of same sheet.

I used below expression to avoid all filters on object except Email ID.

    count({<$(=concat({1<$Field-={'mbrEmailAddress'}>} '[' & $Field & ']=',','))>} mbrID)

It works fine but I have to select associated email ID as selected. Is there any other solution to make associted emailID can be selected to show accounts?

[sebastiandperei]

Hi,

Try with Count ({1<emailID=P(emailID)>} mbrID)