The final tab in the upper setup toolbar is the Sort tab where you can define up to three fields to sort your report results by. Under Sort by, select the field that you want to sort the report by, then choose whether you want results to be sorted in Ascending or Descending order.
Select Sort by another column to add up to three sort criteria. For information about how different data types are sorted, see Sort Rows to Organize Your Data.
Fields used in the Group tab cannot be used in the Sort tab. Instead, you can specify which order groups appear, and how groups are sorted, from within the Group tab. For more information, see Configure Grouping to Organize Results in Report Builder.
Keep the following Dropdown List sorting behavior in mind:
Dropdown List sorting behaves different in Reports and Sheets. When you sort a report, items will be sorted in ascending or descending order. Unlike sheets, if you sort on a column that is a Dropdown List type in the source sheet, items won’t sort based on the predetermined dropdown values in the column properties of the source sheet.
A report can pull from multiple sheets and will consolidate columns with the same name and column type. If the dropdown list columns have different values across sheets (for example: a,b,c,d in one sheet and 1,2,3,4 in another), the report is unable to determine which sort to honor in the consolidated column, so it sorts values as if they are in a Text/Number colum.