Reply
Newbie
Jason LB
Posts: 1

Reporting Question

I am trying to create a report that provides a list of the top 100 contacts by sales dollars with out displaying the contact’s sales total or sales ranking.  This report would provide only the 100 highest producers and would allow a sort by contact name so no one would know what position the contact was in the top 100.  Does anyone know how to limit report results to only include the top 100 contacts?  Or, does anyone know a better solution to this reporting need?

 

Thanks,
Jason

Regular Contributor
flescor
Posts: 88

Re: Reporting Question

I believe you can do this with a report built on the standard report Opportunities with Contact Roles.  You can either create a tabular report showing 100 rows, but not outputting the sales figure, or you could use a dashboard panel (to get top 100 rows) that is fed by a summary report which does not total the sales figure.