Perform Advanced Layout Sorting

If you use relational data, in a list, you can sort columns within groups and change the sort order of columns. In a crosstab, you can sort a row or column by another item, such as Order year by Revenue.

Procedure

  1. Click a column.

    In a crosstab, click the sorted row or column on which to perform advanced sorting.

  2. In the report object toolbar, click the Sort icon sort icon and click Edit Layout Sorting.
  3. To sort a list column within a group, do the following:
    • In the Groups pane, under the Groups folder, expand the folder of the grouped column.
    • In the Data items pane, drag the data items to sort to the Sort list folder.
      Tip: You can also drag data items from the Detail Sort List folder.
    • Click the Sort order icon sort order icon to specify ascending or descending order.
  4. To change the sort order of columns, in the Groups pane, change the order of columns in the Sort list folder of a group or in the Detail Sort List folder.
    Tip: Add items to the Detail Sort List folder to sort items that are not groups.
  5. If you are sorting a crosstab, do the following:
    • From the Data items pane, drag the item on which to sort to the Sort List pane.

      For example, you have a crosstab with Product line as rows, Order year as columns, and Revenue as the measure. To sort Order year by Revenue, drag Revenue to the Sort List pane.

    • Click the Sort order icon to specify ascending or descending order.