Announcement

Collapse
No announcement yet.

List of organizations (without duplicates)?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • List of organizations (without duplicates)?

    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,

  • #2
    Hi olamborelle,

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

    Click image for larger version

Name:	image.png
Views:	125
Size:	15.6 KB
ID:	90217

    ​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.

    Comment


    • #3
      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)

      Comment

      Working...
      X