Sort Data in a List or Crosstabulation Table

To sort individual columns in a table, right-click the heading of the column that you want to sort, and then select Sort Ascending or Sort Descending.
For list tables, when you use this method to sort columns, the sort priority is in reverse selection order. For example, if you select Order Year descending, then Product Name ascending, and then Country ascending, the priority will be Country, then Product Name, and then Order Year.
Note: If measures in the crosstabulation table have been placed on the rows instead of the columns, then you are sorting the rows.
For crosstabulation tables, when you click to sort a column, it replaces any previous column sort that you have specified. You can also sort categories, rather than measures, by clicking the category name.