Multi-level sorting

You can configure sorting grid records by as many columns as you like.

For example, you may want to see the records in the Computers grid sorted by OS and, for each OS, sorted by the current value of the CPU Speed. If there are two or more CPU Speed records with the same current value, of the same OS, you could further sort the records, for example, by HDD Free space.

You can sort grid records by multiple columns by using the following methods:

Note that once you group records by one or more columns, they are automatically sorted by these fields.

When the records are sorted by multiple columns, you can change the order of sorting levels with the exception of sorting by the columns by which the records are grouped. This sorting has the highest priority, such columns are shown at the top of the Sort by These Fields list on the Sorting tab of the Customize View window and their order is defined by the order of grouping.

You can cancel sorting by specific columns except for the sorting by the columns by which the records are grouped. These sorting levels can be cancelled by ungrouping records.

To sort records in the grid:

  1. Sort the records by one column: click the column heading either once to sort in the ascending order or twice to sort in the descending order.

NOTE: If the Group by Sorting option is enabled (for details, see Grouping by sorting), the records get not only sorted by this column but also grouped.

  1. Hold down the SHIFT key and click the heading of the next column you want to sort records by. This will create the next sub-level of sorting.

  2. Repeat Step 2 to sort by as many columns as you need.

To sort a list using the Sorting tab:

  1. Right-click anywhere in the grid and choose Sort > Sort by Form from the pop-up menu.

  2. In the Available Fields pane, double-click the field to sort the records by. If you want to sort records in descending order, select Desc in the Order column. The records will be primarily sorted by this column.

  3. To add more sorting levels, repeat the Step 2 for each field you want to sort records by.

  4. Click >OK.

To change the order of sorting levels:

  1. Right-click anywhere in the grid and choose Sort > Sort by Form from the pop-up menu.

  2. The order of columns in the Sort by These Fields pane defines the order of the sorting levels. Place the columns in the desired positions by using the Move Up and Move Down buttons.

  3. Click >OK.

To remove the applied sorting using the Sorting tab:

  1. Right-click anywhere in the grid and choose Sort > Sort by Form from the pop-up menu.

  2. In the Sort by These Fields pane, double-click the field corresponding to the sorting level you want to remove.

  3. To remove more sorting levels, repeat the Step 2 for each level you want to remove.

  4. Click >OK.