Any way to present deal owners if they have 0 associated deals?

[TPesach3]

Hi community! 

I've made a repot and my client ask to add the names of all the sales reps below even if they have 0 deals that meet the filters, Is it possible? 


Thanks!  

[karstenkoehler · Accepted solution]

Hi @TPesach3,

This can now easily be done with a custom report: https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

1. As a priamry data source, select "Users", as a secondary "Deals"
2. Set up the chart like this
   
3. In the table on the right, click the "Count of deals" column header to sort and display the users with a 0 at the top

That's it 🙂

Best regards