4 Replies Latest reply: Jun 13, 2011 1:57 PM by 849404 RSS

    Selecting distinct results

    849404
      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?