I need to report on all accounts, whom have not a single contact with email.
e.g., an account may have any number of contacts, if neither of the contacts has an email, I want to see that in a report.
The regular filters don't provide me such - if I select a filter with: email not to
- I will get these accounts that have a contact with no email - but it does not ignore the contacts that do have an email. so if an account has 5 contacts, where one does not have an email - it will show on that report.
How to avoid that?