Sort rows by column values

You can sort data in a single column or up to three columns. For example:

• To sort on one column, click the up and down arrows in the column heading to sort the data in ascending or descending order. You may need to widen the column to see the arrows.

• To sort on up to three columns (for all tables except the ones in the Listings or Discrepancies pages):

  1. Select View from the toolbar at the top of the table. Then select Sort > Advanced.

  2. In the Sort By field, select the primary column to sort on and then select Ascending or Descending for the order.

  3. In the first Then By field, select the secondary column to sort on and then select Ascending or Descending. Within the sort order you specified in step 2, the system sorts records in the order you specify

  4. In the second Then By field, select the tertiary column to sort on and either Ascending or Descending. Within the sort order you specified in steps 2 and 3, the system sorts records in the order you specify here.

  5. Click OK.