Advanced table sorting

Sorting records in a table allows you to better understand the data you are working with. A typical example is sorting events, first by Route Id and then by From Measure.

There are four different options for sorting table values:

• Alphanumeric—The selected field's values are sorted as text, even if they are numeric.
• Numeric—The selected field's values are sorted as numerals, even if they contain text.
• Ascending—The values are sorted from A to Z or 1 to 10.
• Descending—The values are sorted from Z to A or 10 to 1.

To sort up to three fields at once, follow the steps below.

1. Click the Advanced Table Sorting tool .
2. In the Sort by area, select the first field by which you want to sort.
3. Click Alphanumeric or Numeric to choose the sort type.
This option will be chosen by default to match the field type.
4. Click Ascending or Descending to choose the sort order.
5. In the Then sort by areas, select the next field and choose a sort type and sort order.
6. Click OK.

When a table's rows are sorted, only the table's display is modified.