Sort a report

Data Explorer allows you to sort the information in your report. Click Sorting in the Question Panel to determine how the data and categories are sorted in a report.

Sorting data

The Data Sorting section allows you to configure the way that the sort tool works to sort a column in a table.

Configure the data sort tool

  1. In a report with a table view type, select Sorting in the Question Panel.
  2. Hover over the column header of the column you want to sort by until the sort tool appears in the upper left corner.

  3. Click the sort arrow, and select the sort direction from the drop-down list. The information from this column appears in the Data Sorting section fields.
  4. Use the Direction field to select a sorting direction.
  5. (Optional) Select the Break Hierarchies check box to apply this sort order to the entire table without respect to other groupings.

Ordering a category

The Category Ordering section allows you to sort the members in a group and designate certain members as exceptions to the order so that they will stay at the top of the list.

Set the order of a category

  1. In a report with a table view type, select Sorting in the Question Panel.
  2. Under the Category Ordering section, locate the category you want to configure.
  3. Select the order from the Sort field drop-down list.

Setting an exception

The Exception field allows you to remove a member of a category from the ascending or descending order set by the sort field. Any member designated as an exception will remain at the top of the list.

Set exceptions to the sorting order

  1. Click Choose Exceptions. The Choose Sorting Exceptions dialog box opens.
  2. Clear the “All values” check box, and then select the check box for the item you want to make an exception.
  3. Click Apply.