Sorting a Results Table

For a non aggregated Results Table or an aggregated table without summary rows, you can sort the table using any of the displayed columns. You can also create a compound sort, where the table is sorted by multiple columns in order.

For example, you can configure a compound sort that sorts by Country, then by Year. In this case, all records for "United States" are grouped together, then sorted by Year within the group.

To set the sorting for a table:

  1. To sort by a single column, click the column heading.

    The rows are sorted by the column values in ascending (A-Z or low-high) order.

    To reverse the sort order, click the column heading again.

  2. To set up a compound sort:
    1. Select View Options > Sort.

      The Edit Sort dialog displays. It shows the current sort order for the table. The rule at the top of the list is used first.

      Note:

      If there is currently a search refinement in place, then the Sort by keyword search term relevance check box is selected.

      Edit Sort dialog for Results Table with the search relevance check box selected.

      You can deselect the check box in order to sort based on the table columns.

    2. To add a sort rule to the list, click +Sort Rule.

      An empty sort rule is added to the bottom of the list.


      Results Table Edit Sort dialog with new sort rule added
    3. To select a column to use for a sort rule, click the arrow for the column name, then from the list, select the column.

      You cannot select a column that is already being used in a sort rule.

    4. To switch the sort direction for a sort rule, click the sort direction arrow in the Order column.
    5. To change the order for applying sort rules, drag and drop each rule to the appropriate location in the list.
    6. To remove a sort rule, click its delete icon.
    7. To save and implement the compound sort, click Apply.