I am trying to use the row limit function on a report to produce the top 10 opps. How do I create a function that can pull the top 10 opps for each rep instead of overall 10?
2 件のコメント
@Kristen Loyek - What you could do is build the Report out and group it by rep and sort the results so the top Opportunities are listed. You can then build a Dashboard and add a Table chart to it and limit the results to 10. If the Dashboard is set up to run as the current user, the person will see just his/her top 10 Opportunities. (Note: If the person clicks through to the Report, they will see all the Opportunities, not just the top 10 Opportunities.) Hope this helps!
