From the Criteria tab, you can set a different sort on each column in a report.
To sort report columns:
On the Oracle BI EE Home screen, select Dashboards, then OFMA, and then Oracle Financial Management Analytics.
Select the report for which you want to manage the columns, and then click Edit.
The Results tab is displayed.
Under the Selected Columns pane, click the menu icon to the right of the name of the column name that you want to sort.
Select Sort, and then choose the sort method for the column:
Sort Ascending
Sort Descending
Add Ascending Sort
Add Descending Sort
Clear Sort
Clear All Sorts in All Columns