Table sorting with cumulative sum (RangeSum)

[Kaninda]

Hi everybody, 

I have a table chart containing the Fields Name, Sales and Cumulative Sales. The latter are calculated through RangeSum formula: RangeSum(Above( Sum(Sales), 0, RowNo())). The calculation with RangeSum works fine, but I want the table sorted by Sales.

As soon as I add the Measure for the Cumulative Sales, the sorting switches to alphabetic sorting by name. In the sorting pane, it stills appears to be sorted by Sales, but that is not what is visible in the actual table. Changing the sorting in the sorting pane has no effect on the chart.

Is there a way to solve this problem? 

Thank you in advance for any suggestions.

[lironbaram · Accepted solution]

hi 

you can work around it , by changing the sorting of the dimension like this 

[Kaninda]

Thank you so much!! It worked perfectly!

[GNA4]

Hi! Same issue in Vizlib table, no option to sort by expression. Do we have any workaround ? Thanks in advance