Sort in ascending or descending order
You can sort data that is displayed in natural or custom order in ascending or descending order.
To sort the data in a field based on the item labels, click the label of the field that contains the data you want to sort.
To sort the data in a field based on the summary values in a column, click a cell in the column that contains the values that you want to sort on.
To sort the data in a field based on subtotal or grand total values, click a subtotal or grand total value for the field that contains the data you want to sort.
Note If you click a grand total value in the bottom row, the columns will be sorted instead of the rows.
Note To sort on multiple fields, start by sorting the innermost field first and work backward, sorting the outermost field last.
Specify a custom sort order
Note If a field with custom sorting has a parent field, each parent member will display the lower-level members in custom order.
Notes