I found a solution to this issue. It works most of the times I have used it, however there have been glitches so be cautious while using it.

In the pivot table, go to Sorting. For the dimension that you want sorted, select Sort by Expression. The Expression you write is:

RANK(The expression of the measure on which you want the dimension values to be sorted).