It seems like this would be simple but I don't know how to accomplish this:
From a report, I need to select certain Activities from Leads who have a unique email address.
I can do a COUNT(Lead."Email Address" BY Lead."Email Address") and filter for those but that just shows me how many have duplicates. I just need the first occurrence of each email.