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:
-
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
-
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