How do I sort cross tables?

In many tables, you will want to sort the tables either ascending or descending to get a better insight. To sort your table(s), follow these steps:

  1. Select the table(s) you want to sort. Right click and the “Options wheel” opens. Select “Edit options”
  2. Scroll down to the “Sorting section” and specify the options:
    1. Sort column: Which column in the table should be sorted.
      1. Count from left to right starting with the total column as number 1. The sorted column will be shown in a grey color.
    2. Direction: The direction of the rolling to be performed
    3. Exclude: Should a number of rows from the bottom to be excluded from the rolling prosess.
      1. Specify the number of rows that shall be excluded from the rolling. Normally this will apply to ‘don’t know’ and ‘other’ alternatives. (these excluded rows will come in addition, even though you also use the maximum option).
    4. Sort maximum:
      1. Specify the maximum (top number) numbers of rows that shall be shown in the table (“Show me the TOP N brands”).
    5. Sorting number: Show the rank number before the row label.

Example, sorting the first column descending and showing only top 5: