Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try with Count ({1<emailID=P(emailID)>} mbrID)