When you add rangesum(above..) expression to table or table equivalent chart, you can not do ordering over other measures, not dimensions. Dimensions keep working on ordering.
But you can order over measures by using a workaround. Define your measures like a dimension. I know it not the best practice but it is working as you wish
Sorted over first dimension:
Sorted over measure and not working:
Sorted over a dimension which is created to show measure value and working:
You should edit your rangesum expression a bit after making these changes
RangeSum(Above(total sum(QTY)/sum(total QTY),0,RowNo(total)))
P.S : After creating this dimension, you should also change its ordering type from auto to custom(Sort numerically) over table properties panel.
Hope it helps...
response above in not fully correct. The reason why sorting is disabled is because of RowNo() function "Sorting on y-values in charts or sorting by expression columns in tables is not allowed when RowNo() is used in any of the chart's expressions. These sort alternatives are therefore automatically disabled."