In a pivot view, you don't have any options to choose the sort order on any measure columns (column grand total include).
If you search to sort on the column grand total, see this article : OBIEE - How to sort on the column grand total value of a pivot view ?.
The steps that perform OBIEE when it create an pivot view are :
Unfortunately, a pivot view is always sort by dimension.
Then you can in the pivot view choose :
but the first order of the lowest dimension will always repeat.
In our above example, I have sort by year and by value of direct sales but I will get always this sort :
The promotion sort is chosen during the first pass of the data in the table view.
I know only one solution which is to :