How to report number of deals per company (only primary company) if deal associated with multiple

[CMauer]

Hello,

I have the following issue: I need a report (chart) in HubSpot where I can clearly see how many deals there are per company. However, we always have to associate deals with multiple companies because we need to bill a different company, but then the billing company also appears in the report, and each deal shows up multiple times. Each deal should only appear ONCE and only be listed under the primary company. How can I set this up?

Thank you in advance

[karstenkoehler · Accepted solution]

Hi @CMauer,

When creating a report in the custom report builder across two objects, you can specify that it should only reflect certain association labels:

Select "Primary" there and you should see the results you're looking for:

Best regards!