Sorting values in cross table ignoring the hierarchy
You can sort the values in a cross table globally, that is, any created hierarchy in the cross table will be ignored when sorting. You can sort the values in ascending or descending order.
About this task
Note: Only the values in a
cross table column can be sorted globally.
Procedure
-
In the opened menu, beneath
Sorting, click
to sort from lower to higher values, or click
to sort the from higher to lower values.
The values in the entire column are sorted, and the hierarchical structure is no longer displayed. An arrow in the header indicates the sort order.Note: You can click None to return to the default order.Tip: You can press Shift + click the header to switch the sort order.
Example
The cross table below displays data hierarchically. It shows quarterly sales figures for 2016 and 2017, split by location and gender.
If you click a column header, for example Q3 in 2016, and select
in the menu, the values
within the entire column are sorted from lower to higher values. In consequence
of this, the hierarchical structure can no longer be displayed.
