You can configure sorting grid records by as many columns as you like.
For example, you may want to see the records in the Software Licenses grid sorted by category and, for each category, sorted by the software license’s current value. If there are two or more software license records with the same current value, in the same category, you could further sort the records, for example, by expiration date.
You can sort grid records by multiple columns by using the following methods:
Sorting records directly in the grid. This method allows to sort records by as many visible columns as you want.
Sorting by using the Customize View tab. This method provides a convenient form for choosing columns to sort by and the sort order.
NOTE: 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.
To sort records:
Click the column heading. To change the sorting order, click it again.
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.
To add another sorting level, hold down the SHIFT key and click the heading of the next column you want to sort the records by. This will create the next sub-level of sorting.
Repeat this step to sort by as many columns as you need.
Right-click anywhere in the grid and choose Customize View from the pop-up menu, then open the Sorting tab of the Customize View window.
In the Available Fields pane, click the field to sort the records by
and click Add. If you want to change the sorting order, click in the Order column in the Sort by These Fields pane and select Desc for descending order or Asc for ascending order.
To add more sorting levels, repeat this step for each field you want to sort records by.
To remove sorting, remove fields from the Sort by These Fields pane.
- Click OK.