In a workspace, it is possible to sort the data in an ascending and descending order. When you arrange the data in an ascending sort, you have data with smaller values at the top. A descending sort arranges data with larger value at the top. By default, in an analysis, data is sorted in a descending order.
In a Crosstab analysis, select the row or column that you want to sort. On the toolbar, choose Analyze tab at the top. To apply sort, click the arrow next to Sort. You can also right-click on any key figure or hierarchy in Row/Column tab and select Sort option → A to Z or Z to A.
When we apply a sort on Company code in Z to A sort order, the values will be changed in the main analysis.
This has a sorted value in alphanumeric sort order.
You can also reverse the sort order from ascending to descending and vice versa. To reverse the sort, select the other sorting order.
It is possible to remove a sort in an analysis manually or automatically. To remove a sort manually, you can right-click the member header -> Select Sort, and then click Remove sort, or right-click the Sort icon beside the sorted member's name and click Remove sort.
A sort is automatically removed when one of the following action is performed −
When you select swapping hierarchies, removing a hierarchy, or adding a hierarchy results in sorts and filters being removed.
When you use nesting hierarchies, this removes the value sorts; however, member name sorts remain and filters are not affected.