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?