Configure Sorting

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:

1. Go to Reporting and Analytics > Reporting > Reports and open the report that you want to add sorting to.
2. Click Sorting.
3. In the Sorting dialog box, click Add to add another column to sort by.
4. Click Please select a field, and then select a field in the drop-down list.
5. 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.
6. (Optional) Add more fields to sort by.
7. (Optional) To adjust the sort order, select a field and click Move Down or Move Up.
8. Note: Grouped fields must always be at the top of the list. You can change the order of grouped fields in the Grouping dialog box. See Configure Grouping.
8. 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 to update the data sample.
9. Click Save.