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.
- Click the header of the cross table column whose values you want to sort.
- 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 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.