Sorting Data in a Crosstab

In crosstabs, right-click a column heading to sort data. You can also sort categories, rather than measures, by clicking the category name.
To specify a sort for values in a crosstab:
  1. To sort by category values in a crosstab, right-click a column or row heading. Then select Sort. Then select either Ascending or Descending.
    Sort Menu for a Category in a Crosstab
    Sort Menu for a Category in a Crosstab
  2. To sort by measure values in a crosstab, right-click a column or row heading. Then select Sort. Then select either Ascending by Value or Descending by Value.
    Sort Menu for a Measure in a Crosstab
    Sort Menu for a Measure in a Crosstab