Sorting values in a cross table
You can sort the aggregated values in the cross table columns as well as in the cross table rows.
About this task
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. When the values are sorted, an arrow in the header
indicates in which order.
Note: If the cross table is structured hierarchically, the values are sorted within each of the smallest subcategories. See the example at the bottom.Note: You can click None to return to the default order.Tip: You can press Shift + click the header to switch the sort order.
Examples
The cross table below visualizes data hierarchically on the horizontal axis as well as on the vertical axis. It shows quarterly sales figures for 2021 and 2022, split by location and gender.
If you click a column header, for example Q3 in 2021, and select
in the menu, the
values are sorted from lower to higher values within the last subcategories of
the hierarchy. That is, the male and female sales figures are sorted in
ascending order within each store location.
If you instead click a row header, for example Male in New York as
shown below, and select
in the menu, the values
within each of the last subcategories, Q1-Q3 2021 and Q1-Q3 2022, are sorted in
an ascending order.
