The rows and columns that consist of a crosstab are sorted by default in alphabetical order of the group names.
Sorting your crosstab
Select the heading you want to use for sorting, right click on it and select one of these options:
- Sort Ascending
- Sort Descending
- Don’t Sort
- Right click on the heading you want to use for filtering and select one of the following:
-
- Filter Top N Values
- Filter Bottom N Values
- Don’t Filter Values
- Specify the number of values you want to show in the crosstab.
- Choose if you want to show an aggregate of the unranked values in the crosstab.
- Choose if you want to apply the filter in all your created groups.
- Click on OK to finish.