Hi I am trying to create a salesforce report to show the 3 columns

  1. Contact owner
  2. number of contacts per owner
  3. whether contacts have any activity on them or not(sum of relation)

My report looks something like below but I want to show just the number of contacts per user not the name of the contacts, could someone please help me to achieve the numbers instead of names?

enter image description here

1 Answer 1


You need to uncheck the details rows option and group by Contact Owner in the report and run it. Refer to the image below and see the options available at the end.

The best place to learn about reports and dashboard is Trailhead. Learn more about grouping here:- Group and Categorize Your Data

enter image description here

If you want to show the columns with the count, then check the details rows only and it will appear as follows:-

enter image description here

  • Thank you, Sanket, this way I get only 2 columns but I want all 3 of them
    – gs650x
    Feb 12, 2019 at 7:41
  • @gs650x find the update in my answer Feb 12, 2019 at 8:07
  • Thank you again, but this still doesn't serve the purpose
    – gs650x
    Feb 12, 2019 at 8:10
  • The third field is some of the relation count which shows the number of activities per contact. The first name,last name and created date is not required I just want 3 fields contact owner, number of contact per owner and number of activities per contact
    – gs650x
    Feb 12, 2019 at 8:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .