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 select the required dashboard.
Select the report for which you want to manage the columns, and then click Edit.
Select the Criteria tab.
Under the Selected Columns pane, click 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.