Top 5 Producers Chart Creation
![Tony Fronza](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hello! We want to post a top 5 (or 10) list on a dashboard to dynamically display producers with the top 5/10 highest total sales in both count and $ amount. We have a master sheet to capture this information but cannot find the right formula or approach (maybe a helper column?) to produce this.
Any help is greatly appreciated!
Answers
-
Hi @Tony Fronza - I would recommend a helper column with the RANKEQ. Which item is highest sales: the count or the amount? You'd need to use that to determine the helper column. Your formula for that column might look like this:
=RANKEQ(Sales@row, Sales:Sales)
This formula will rank each row (individual) from your master sheet. Then, you can set up a report with the filter of showing if the Helper column is "between 1 and 10".
Please let me know if that helps!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!