Sorting data is a fundamental part of data analysis. It helps you understand your data better as you can visualize and organize different views on the data in your crosstab. With sorting the data, you are able to quickly identify the data you need for your decisions.
You can sort data by values (smallest to largest and largest to smallest) and members (A to Z and Z to A). If you sort the values of one measure (for example sales volume) from smallest to largest, the other cells in your crosstab are also affected by the sorting. The metadata information therefore remains correct in the crosstab.
If you select ascending sorting, the data is sorted from smallest to largest. Ascending sorting for members results in sorting from A to Z.
If you select descending sorting, the data is sorted from largest to smallest. Descending sorting for members results in sorting from Z to A.
In the default setting, data is sorted in the hierarchy levels of the crosstab. Parent members are sorted in order, and child members are sorted below each parent member in their own order. If you want to sort data across the entire hierarchy, select the Break Hierarchies option.