Sorting Data in a Crosstab

To sort by category or measure values in a crosstab, right-click on a column or row heading, and select Sort. Then, select either Ascending or Descending.
Sort Menu Items for a Crosstab
Sort Menu Items for a Crosstab
You can also sort categories, rather than measures, by clicking the category name.