How can you sort records in a report?

Click a column heading to sort the detail rows by that column, or use the group header menu to sort groups by a value or summary. Both are described in Salesforce Help: Sort Report Results .

How do I add a record count to a Salesforce report?

Group the report by any field and Salesforce adds a Record Count per group and a Total Records figure. Turn on the Row Counts toggle at the bottom of the run page to show it beside each group.

What is the default number of rows in a Salesforce report?

The builder preview shows up to 20 rows for summary and matrix reports and 50 for tabular. The run page displays up to 2,000 rows; export the report to see more.

Why does the report preview show a different record count?

The builder previews a limited number of records. Our preview showed 6 opportunities for one account while the run report showed all 10, so always check counts on the run page.

Can I sort report groups by record count when I build reports through the API?

Yes. Set "sortAggregate": "RowCount" on the grouping in groupingsDown and include RowCount in aggregates. The field is listed in the Reports and Dashboards REST API reference .

Salesforce Report Sort by Record Count (Fix + Steps)

You open a summary report, click the Record Count header, and nothing sorts. Or your report is tabular and there is no count to sort by at all:

Record Count column header: no sort arrow
Tabular report: no "Sort by Record Count" option

The sort lives on the grouping, not on the Record Count column. Open the arrow on the group header (Account Name in our report), choose Sort By, pick Record Count, then Sort Descending.

That is the whole fix for a Salesforce report sort by record count. Below are the reasons it fails, the tabular, chart and filter cases, and how to set the same sort through the API.

This Tutorial Covers: