SELECT count(id), Email , FirstName, Lastname, Account.Name
FROM Contact
group by Email, FirstName, Lastname, Account.Name
having count( Email ) > 1
order by count( Email ) desc
How can I filter only those having count(email) > 1
Thanks,
Allison
7 个回答
I believe so. Are you looking only for Contacts that have an email or those that have more than 1. If the latter, are you storing additional emails in a secondary field or a custom object?
Your report type will help satisfy your FROM requirement and you would drag and group fields onto your report canvas to satisfy the SELECT requirement. You can't group by more than 3 levels, so you can't do all of those.
Based on the answer above, you will likely also need to create a filter on the report.
