You can sort the records that the report returns by one or more columns. Columns that have grouping applied must also be sorted, and by default they’re automatically sorted in ascending order. For grouped columns, you can reverse the sort order, but you can’t remove the sorting.
To apply sorting on your report:
- Go to Reporting and Analytics > Reporting > Reports and open the report that you want to add sorting to.
- Click Sorting.
- In the Sorting slide-out panel, click Add Field to add another column to sort by.
- Select a field in the drop-down list.
- Make a selection in the Sort Order drop-down list. The options available depend on the data type of the column: A to Z for strings, smallest to largest for numbers, and oldest to newest for dates.
- (Optional) Add more fields to sort by.
- (Optional) To adjust the sort order, click the down or up arrows next to a field.
- Note: Grouped fields must always be at the top of the list. You can change the order of grouped fields in the Grouping slide-out panel. See Configure Grouping.
- Click Apply.
- If auto-preview is enabled, the sample data is updated with the changes automatically. Fields that have sorting applied are now displayed in a darker shade of gray.
- If auto-preview isn’t enabled, click Preview, then Run Preview to update the data sample.
- Click Save.