List of organizations (without duplicates)?

[olamborelle]

Contacts have an "organization" field. Within each organization, we may of course have several contacts.

How could we generate a list of all organizations, without duplication (if e.g. we have 2 or 4 contacts in that organization)?

I tried with report of entities "Contacts" but how could I remove duplicate? (other than exporting as Excel and removing duplicates there).

Thanks,

[lazovic]

Hi olamborelle,

Please tell me, if I understand you correctly, do you want your report to look something like this?



Also, what is the relationships between the Organization entity and the Contact entity? This information is necessary for a more detailed analysis, so that I can help you faster.

[Jakub Grufik]

Hello, create GRID report for Contact, GROUP BY: Organization, COLUMNS: COUNT, this will do what you are looking for where first column will be list of organizations and second column number how many contacts is pinned to the organization (you do not have to use that column with number)