Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Step 1: Defining Criteria in Analytics > Sorting and Reordering Columns

Sorting and Reordering Columns

You can specify multiple levels of sort order for the columns in an analysis. For example, you can specify that the records will be sorted first by Column A, then by Column B, and so on. If one or more sort levels are applied, then the sort levels are indicated by numbers, and the sort direction (ascending or descending) for a column is indicated by an arrow.

To sort an analysis based on columns

1. In the Criteria tab of the analysis editor, in the Selected Columns pane, click the drop-down list of options for the desired column and choose Sort.
2. From the Sort submenu, choose one of the following:
   • Sort Ascending. Sorts this column as the first-level sort, with the lowest values at the top, and the highest values at the bottom. If a sort setting was previously applied to another column, then the sort setting is cleared from that column.
   • Sort Descending. Sorts this column as the first-level sort, with the highest values at the top, and the lowest values at the bottom. If a sort setting was previously applied to another column, then the sort setting is cleared from that column.
   • Add Ascending Sort. Sorts this column in ascending order as an additional sort level to any sort setting already applied to other columns. Any sort settings applied to other columns are not cleared.
   • Add Descending Sort. Sorts this column in descending order as an additional sort level to any sort settings already applied to other columns. Any sort settings applied to other columns are not cleared.
   • Clear Sort. Removes any sort setting that was applied to this column in the Selected Columns pane of the Criteria tab. If a sort setting was previously applied to this column in a view in the Results tab, then that sort setting is not cleared.
   • Clear All Sorts in All Columns. Removes any sort settings that were applied to any of the columns in the Selected Columns pane of the Criteria tab. Any sort setting that was previously applied to a column in a view in the Results tab is not cleared.

     When you click the Results tab, the column is sorted based on your selection.

To reorder columns

• In the Criteria tab, drag columns from their current location to a new location.

NOTE: When you create a new analysis, the order of the columns in the Criteria tab determines the order of the columns in the Table view that is displayed by default when you first open the Results tab. However, after you open the Results tab in the analysis editor, reordering the columns in the Criteria tab does not change the order of the columns in any view in the Results tab; if you want to reorder the columns in a view, then you must edit the view in the Results tab.