Right-click a column header on upper pane and choose
Sort and Group.
Right-click in the upper pane and choose
Filters > Sort and Group.
The
Sort and Group dialog box displays four group boxes, each indented slightly more to the right than the one above it. The first group box
designates a primary sort order, the second designates a secondary sort, and so on.
Optionally, check the
Show Advanced Fields check box at the bottom of the dialog box to list all the fields in
First By and
Then By lists. Some fields are rarely used and considered advanced.
Select a field from the
First By list.
If you are grouping the items, the field does not need to be displayed in the upper pane. If you are not grouping the items,
you can sort them based on a field that is not displayed, but you will not be able to tell where one group leaves off and
the next begins.
Select the
Ascending or
Descending option button. The default setting is ascending order.
Select
Group By to group the items which have the same values in this field.
If you do not select any additional sort options, text fields are sorted in ASCII order. Enumerated and user ID fields are
sorted by their internal order or internal keys. That is, enumerated fields are sorted in the order given to them by the person
who created the field; user ID fields are sorted in the order in which they were created. The application disables the Sort
Options button for numeric and date/time fields.
Optionally, click
Sort Options for additional sorting selections. The
Sort Options dialog box appears.
Select
As Text to sort enumerated and user ID fields by the names of their possible values. For text fields,
As Text is your only choice.
Uncheck the
Case-sensitive check box to sort alphabetically or check it to sort in ASCII order (where uppercase letters precede lowercase letters).
Add secondary and lower order sorts by using the
Then By Group boxes as needed.