This content has been marked as final. Show 4 replies
simply use a rank function and filter for the latest one.1 person found this helpful
Thanks for the response. I see the Rank function working correctly I'm just not sure how to construct the filter to select based on it.
Please try applying COUNT(DISTINCT Lead."Email Address") and check if the result is being obtained.
Doesn't seem to do it, I just get a count and it shows the duplicates still.
Email , Count Distinct , Activity ID
Email@example.com, 1, AHMA-77SVKI, 1, AHMA-77SXEK