Running totals in stacked bar chart

[AndriyShepel]

Hi folks

I am struggling  in making the correct calculation of the running totals sub in stacked bar chart.

In the attached qvw file you will see the correct (expected calculation) of the total running sums per day, however, if I add another region dimension, the calculations are completely wrong (seems, something is happening with the date/region sorting)

The one above - expected calculations, the one below - incorrect

The expression which is used for the running totals is the following:

sum(Amount)+RangeSum(TOP(sum(Amount), 1, RowNo()-1)) 

Let me know please if someone has an idea how to deal with this

Thanks!

[MK_QSL · Accepted solution]

=Aggr(RangeSum(Above(sum(Amount), 0, rowno())), Region, Date)