Sort Data in a Crosstabulation Table

In crosstabulation tables, right-click a column heading to sort data. You can also sort categories, rather than measures, by clicking the category name.

Note: If measures in the crosstabulation table have been placed on the rows instead of the columns, then you are sorting the rows.

To specify a sort for values in a crosstabulation table, complete these steps:

To sort by category values in a crosstabulation table, right-click a column or row heading and then select either Sort Ascending or Sort Descending.

Sort Ascending and Sort Descending Menu Options for a Crosstabulation Table
To sort by measure values in a multidimensional crosstabulation table, right-click a column or row heading and then select Sort Ascending, Sort Descending, Ascending across Hierarchies, or Descending across Hierarchies.

Note: There is a difference between the Sort Ascending and Sort Descending options and the Ascending across Hierarchies and Descending across Hierarchies options. The Ascending across Hierarchies and Descending across Hierarchies options are available only for measures. You can sort either row or column data. However, the sort is relevant only for the measure that you select. For example, in the following display, the Cost N column for Canada is selected, so it will be the measure that is sorted when you select either the Ascending across Hierarchies or Descending across Hierarchies option. You can sort across a hierarchy or within a hierarchy depending on the measure that you select.

Sorting Options for a Multidimensional Crosstabulation Table