Sorting Data in a List Table

Sort Values in a List Table

To sort individual columns in a list table, the sort priority is in reverse selection order. For example, if you select Order Year descending, then Product Name ascending, and then Country ascending, the priority will be Country, then Product Name, and then Order Year.

To specify a sort order for values in a list table, complete these steps:

Right-click a column heading in the list table, and then select either Sort Ascending or Sort Descending.
To sort additional columns in order of priority, right–click each column heading and then select either Sort Ascending or Sort Descending.

Sort Ascending and Sort Descending Menu Options for a List Table

Specify a Sort Priority for Values in a List Table

If you are working with a relational list table in Edit or View mode, then you can specify a sort order for the values. To specify a sort priority for values in a list table, complete these steps:

Right-click in the table and select Sort Priority. This opens the Sort Priority dialog box.

Sort Priority Menu Item for List Tables in Edit Mode

Sort Priority Menu Item for List Tables in View Mode
In the Sort dialog box, specify which item you want sorted first. You can sort multiple columns. In the following display, the list table is sorted first by height and then by age.

Sort Dialog Box with the Height and Age Columns Selected

Note: The Sort Priority option is not available for list tables in a synchronized group.