First you identify what you want to sort. Then you identify how you want to sort the data. Finally, you define what value to sort on.
1. Open the report/input schedule containing the data you want to sort.
2. Open the Report Editor.
3. On the Body tab, select the row or column of data that you want to sort. For example, if you want to sort Product data, select the row (or column) that contains Products.
4. In the Sort Options field, select Ascending or Descending order.
5. In the Sort Col/Row field, select the column (or row) that contains the value to sort. For example, if you want to sort Product data for the Actual scenario, select the column (or row) that contains the Actual scenario.
6. Click OK to close the Report Editor and view the results.