Avatar

Employee Advisor

Its not clear what you want. Initially you said "filter out all the records", then you are saying you want to keep the ones that get filtered out.

 

Do you want to aggregate the values? Or do you want to market to one person? What is the result you want?

 

If you want to aggregate check out step 1 here:https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/use-cases/d... 

instead of Max(), you can use Count(). That will give you that total count per person, while keeping all the records.