Skip to main content
Sarah-Anne
Contributor ⭐️
Jun 26, 2023 8:21 AM UTC
Question

Report filter for top 10 ARR

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

Is this available in reports?

    3 replies

    alizee
    alizee
    VIP ⭐️⭐️⭐️⭐️⭐️
    Jun 26, 2023 9:57 AM UTC

    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. 

    Translate
    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
      Nikhil kumar
      Helper ⭐️
      Jun 26, 2023 1:43 PM UTC

      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.

       

      Translate
        Sarah-AnneAuthor
        Contributor ⭐️
        Jun 26, 2023 1:49 PM UTC

        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.

         

        Translate
          Terms & ConditionsAccessibility statement