Hi there,

I would like to run a deal summary report that groups by contact roles, but a bit more nuanced. I don't want to group by the 'roles' but rather the contacts themselves. You see, our deals always involve >1 contact, there in lies the need to utilize roles. However,  I cannot find a report that allows you to use the contacts under contact roles, just the roles themselves. I've also created a custom field that allows us to add our people from a pick list. I can group that way, however, the report is messy as it does not separate the individuals from the pick list. i.e. I'll get something like this:

person 1 (3)

person 1;person2;person3 (1)

person 2 (2)

person 2;person 3 (1)

it groups by any variation of people instead of the individuals themselves. Any method of solving this problem of not being able to see indivdual contacts for a deal as a grouping under a deal report would be greatly appreciated. I have a custom field in details where they are listed and they are all in contact roles. Thanks!