Sorting a record list table or an aggregated table without summary rows

For a record list 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.

So for example, you could set up a compound sort to sort by Country, then by Year. So all of the records for the United States would be grouped together, with those records then sorted by Year.

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. In the View Options menu, click Sort.

      The Edit Sort dialog is displayed. It shows the current sort order for the table.

      On the dialog, you create the list of sort rules. Each rule includes the column to sort by and the sort direction. The rule at the top of the list is used first.

      Note that if there is currently a search refinement in place, then the Edit Sort dialog includes a checkbox to indicate whether to sort by search relevance.


      Edit Sort dialog for Results Table with the search relevance checkbox
    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 drop-down arrow for the column name, then from the drop-down 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 in which to apply the 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.