Show TOC

Sorting in Ascending/Descending OrderLocate this document in the navigation structure

Use

The functions Sort in Ascending Order and Sort in Descending Order sort the report rows in ascending or descending order for one or more columns.

Procedure

Sorting Rows in a Column in the List

  1. Select a column by clicking on the column header.

  2. Choose Sort in Ascending Order or Sort in Descending Order , or Start of the navigation path Edit Next navigation step Sort in Ascending Order End of the navigation pathor Start of the navigation path Edit Next navigation step Sort in Descending Order End of the navigation path.

    The rows are sorted in the column selected.

    Note

    If you use this procedure in a multilevel sequential list, you can sort by a maximum of one header column and one subordinate row.

Sorting According to Multiple Columns or Fields Not Displayed

  1. Choose Sort in Ascending Order or Sort in Descending Order , or Start of the navigation path Edit Next navigation step Sort in Ascending Order or Sort in Descending Order. End of the navigation path.

  2. The dialog box Define Sort Order shows the fields you can sort. Fields are also available that are not shown in the list.

  3. You can limit the fields available in the list for sorting by choosing a field group that contains the desired fields.

  4. To select fields for sorting, select the relevant rows and choose Show Selected Fields (arrow key). The selected fields then appear in the dialog box as sorting fields.

    Note

    You select the sorting fields in multilevel sequential lists separately for header and item.

  5. The sequence in which the sort fields are shown determines the sequence in which the columns are sorted. To change the sequence of the fields, use the functions Cut and Paste .

  6. Use the radio buttons to specify whether the report rows are to be sorted in ascending or descending order within the column.

    Example

    You want to sort a list by cost centers and activity types. In the dialog box, choose the cost center and activity type as the sorting criteria. In the list of selected sorting fields, the cost center must be above the activity type. Use the radio buttons to specify ascending sequence. The result is a list sorted by cost center. The activity types are listed in ascending order for every cost center.

  7. Exit the dialog box with Copy .

    Note

    If you use this procedure in a multilevel sequential list, you can sort by multiple header columns and item columns.

    Note

    If you have sorted according to particular fields, you can obtain an overview of the current sort with Sort in Ascending Order or Sort in Descending Order . The dialog box Define Sort Order appears. The left half of the window shows all fields that were sorted by.

    You can also use the List Status function for an overview of the selected sort criteria.

More Information

After sorting, you can create subtotals on selected fields. (See also: Creating Subtotals )