Configuring the default Results Table sort order and summary row display

The Sorting & Summaries tab on the Results Table edit view allows you to configure the default sort order to use for the table. For aggregated tables, the tab also determines whether to enable the dimension and table summary rows.

For record list tables and aggregated tables without dimension summary rows, you create a list of sort rules, which are applied in order. For each sort rule, you can select a different column and determine whether to sort in ascending or descending order.

For aggregated tables with dimension summary rows, the sort rules use the dimension columns from left to right, with each dimension sorted in ascending order. You cannot change the order of the sort rules, and you cannot add or remove sort rules. You can only:

• Change the sort direction of each dimension (ascending or descending)
• Change the attribute used in the last sort rule. By default, it is the last dimension in the dimension list, but you can instead select a metric column. The values in the metric column then determine the order of the values for the last dimension column.

Note that on the end user view, only the currently visible columns can affect the sort order.

On the Summaries & Sorting tab, to configure the sorting:

1. In the Maximum number of sort rules field, type the maximum number of rules that can be used in a compound sort.
2. For record list tables, or aggregated tables that do not display dimension summary rows, to configure the list of sort rules:
   1. To add a new sort rule, click the +Sort Rule button.

      If the maximum number of sort rules already has been added, then the button is disabled.

   2. To change the column assigned to a sort rule, click the drop-down arrow next to the column name, then select the new column.
   3. To change the sort direction for a sort rule, use the sort direction drop-down list.
   4. To change the order in which to apply the sort rules, drag each sort rule to the appropriate location in the list.
   5. To remove a sort rule, click its delete icon.

      If there is only one entry, you cannot remove it.

3. For an aggregated table that does display dimension summary rows, to configure the sort rules:
   1. To change the sort direction for a sort rule, use the sort direction drop-down list.
   2. To change the column used in the last sort rule, click the drop-down arrow next to the column name, then select the new column.
4. For an aggregated table, the Summaries section of the Sorting & Summaries tab also allows you to configure whether to display summary rows by default:
   
   
   
   1. By default, the dimension summary rows are not displayed. To display by default the dimension summary rows, check the Show summary rows by default checkbox.
   2. By default, the grand summary row is displayed. To not show the grand summary row, uncheck the Show a grand summary row by default checkbox.