Skip to main content
Contributor ⭐️
June 26, 2023
Question

Report filter for top 10 ARR

  • June 26, 2023
  • 3 replies
  • 145 views

I am looking to create a report to show the top 10 customers by ARR.

Is this available in reports?

3 replies

alizee
VIP ⭐️⭐️⭐️⭐️⭐️
June 26, 2023

Hi @Sarah-Anne It sure is if you have ARR data fed into your Company object. You’d then look to apply a “limit” to your report to show X records (10 in your case) in settings. 

The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
Nikhil kumar
Helper ⭐️
June 26, 2023

Hi @Sarah-Anne 
Alizee have given the right approach just to Help you understand it more below are the steps you need to perform.

  1. Create the Report with whatever fields you need,  don’t forget to add the ARR field in the Show me section.
  2. Goto Settings on the report→ Ranking and Sorting →Select the field you want to apply the Sorting (In your Case ARR) → Then Just use the Limit of 10 there, You will have your dataset ready in Report.

 

Contributor ⭐️
June 26, 2023

Thank you both, I have been able to build the report using these steps. 

My original Report was in scorecard widgets and this option was not available. I have changed this now to be able to use this option.