Salesforce Report Sort by Record Count: Quick Grouping Method

I’ve built hundreds of Salesforce reports, and sorting by record count always stumps new users. The interface hides this option in plain sight under grouping settings.

What most don’t realize is that you can sort grouped data by count without writing a single line of code. It takes under 2 minutes once you know where to look in the report builder.

You’ll get clean, organized data showing which groups have the most records at a glance. This works for any standard or custom object, and the method stays consistent across Salesforce versions.

No special permissions required—just access to the report type. Here’s how to set it up properly the first time.

What Youll Need

Instructions

This method is fast and works in both Classic and Lightning Experience.

Navigate to the Reports tab and either create a new report or open an existing one. I always start with a Tabular or Summary report type since these support grouping and sorting by record counts most reliably.

If you’re creating a new report, select the appropriate report type based on your object. For example, use Accounts & Contacts for contact-related counts. Save it with a clear name so you can find it later.

In the report editor, drag the field you want to group by from the Fields pane into the Group Rows section. For example, if you want to count records by account, drag the Account Name field here.

This creates groups based on unique values in that field. You’ll see the groups appear in the preview, but they won’t be sorted yet. This is where the record count logic comes into play.

Click the Add Column button in the report editor. In the popup, select Record Count from the list of available fields. This adds a column that automatically counts the number of records in each group.

If you don’t see Record Count as an option, ensure you’re using a Summary or Tabular report format. Matrix reports handle counts differently and may not support this method directly.

Click the dropdown arrow next to the Record Count column header. Select Sort by, then choose Descending or Ascending based on your needs. Descending puts the groups with the most records at the top.

Verify the sort by checking that the group with the highest count appears first. If it doesn’t, double-check that you’ve selected the correct column to sort by.

Click Save to apply your changes, then Run Report to see the results. The report will now display groups ordered by their record counts, making it easy to identify which categories have the most or least entries.

If the counts seem off, ensure your report filters aren’t excluding records unintentionally. A quick check of the total count at the bottom of the report can confirm this.

Tips and Common Mistakes

This quick method works best when you understand the common pitfalls and how to avoid them.

Report Type Selection: Stick with Tabular or Summary formats as mentioned in Step 1—they handle record counts most reliably. I learned the hard way that Matrix reports often complicate this process with their different grouping logic, making your counts inaccurate or harder to sort.

Field Grouping Clarity: When dragging fields into the Group Rows section in Step 2, ensure you’re using the exact field you want to analyze. For example, using Account Name instead of Account ID prevents confusion and gives you the clear grouping you need for accurate counts.

Column Verification: In Step 3, if Record Count doesn’t appear as an option, double-check your report format first. I’ve seen users waste time troubleshooting when they simply needed to switch from Matrix to Summary format to access this critical counting feature.

Sorting Confirmation: After sorting in Step 4, always verify the highest count appears first. It’s easy to accidentally sort by the wrong column, especially when you’re working quickly. A simple visual check saves you from presenting incorrect data.

Frequently Asked Questions

Sorting Salesforce reports by record count is a powerful way to quickly identify trends and prioritize data. With just a few clicks, you can transform raw data into actionable insights. Try applying this method to your next report and see how it streamlines your analysis! 🎯