Sorting Data

Sorting is accessed either from the Analysis ribbon or from a context menu.

The figure shows the two options for sorting dimensions in the crosstab: use the Analysis ribbon or right-click and use the context menu options.

There are three basic approaches to sorting dimension members:

• Sort Ascending - Ascending sort by the currently selected dimension’s current member display type
• Sort Descending - Descending sort by the currently selected dimension’s current member display type
• More Sort Options - Opens a sort by dialog, allowing you to chose more sophisticated sorting techniques

The figure shows the three dimension sorting options: Ascending, Descending, and More Sort Options.

You can sort measure data by values. If you have multiple measures in your crosstab and sort the values of one measure (for example, Sales Volume), the other cells in your crosstab are also affected by the sorting.

Watch the video to see how to sort data in the crosstab.

Let's summarize:

• Sort Dimensions: Access sorting from Analysis ribbon or context menu; options include Sort Ascending, Sort Descending, More Sort Options.
• Sort Measures: Sort measure data by values; sorting one measure affects entire crosstab.