Hi;
I'm looking for a way to take 3 lists and only keep the people that are in all 3 lists.
Like a ven diagram anyone who doesn't fall into all 3 lists I don't want to see.
I tried just pulling a list that used all of this criteria in it but it was unable to pull anyone as I was re-using very specific criteria sets though when I to into the accounts I can see that they should be pulling hundreds of constituents.
I am pulling on Performance Date and Performance Title so with this am able to get constituents that are going to 2 of the shows but once I re-use one of those criteria the list generate no-one.
Please help.
Hi Cathy-Anne,
Have you tried taking a fourth list and adding separate criterions of each list with an operator of HAS?
So your set would look like this
List HAS [list 1]List HAS [list 2]List HAS [list 3]