4 Replies Latest reply on Jun 13, 2011 6:57 PM by 849404

    Selecting distinct results

      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.

      Any ideas?