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.

Note: Only the values in a cross table column can be sorted globally.

Procedure

  1. Click the header of the cross table column whose values you want to sort.
  2. In the opened menu, beneath Sorting, click Global sort, ascending to sort from lower to higher values, or click Global sort, descending 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.