Question

Is there a way . . . to total results from pick list per Company?

  • 28 October 2022
  • 2 replies
  • 18 views

We define a “role” for “Company/Relationship Person” and the value for this role is managed by a pick list. I can generate a report from Company/Relationship Person and include this field in a report.

The problem I’m trying to solve is when I add these fields in “Show Me”:

  • Company Name
  • Role1
  • Role2

It results in a report that has multiple lines per Company (one for each Person with that role). What I want is one line per company with totals for each role.

How could I accomplish this?
 


2 replies

Userlevel 7
Badge +9

@pjstrifas Anytime you’re looking for aggregation, or math, on a field, you can also use the Group By section of a Report.

For this use case, consider

  • Show Me: Count of GSID
  • Group By: Company > Name

The above would give you a count of Persons at each Company, one row per Company.

  • For bonus points: Also Group By: Role and then activate a Pivot inside the Settings of Role.

This extra step would still render one row per Company, and you’ll also have columns for each Role, to discern how many Persons are within each Role.

I believe this will work! Thank you!

Reply