Cumulative Sum with many dimensions and expression sorted

[jchoucq]

Hi,

in a straight table, i've got 3 dimensions and an expression which i sort descending. Everything is ok.

Then, i would like, to have another column which must be the cumulative sum.

I must keep the sort order and have a cumulative sum from the first row to the last one.

Whatever the solution i try (Full Accumulation, Above, SumRange ..), it doesn't work !

Does anyone have an idea ?

You can look at my attached qvw.

Regards,

Johann

[lenka_kruse · Accepted solution]

Hi,I got at least the cumulation by changing the expression to this:
rangesum(above(total cumul), sum(CA))

but I don't know why the sorting won't work - looks to me like a bug, since the sorting is shot to hell as soon as the second expression is added/activated. I'm sure that's not supposed to happen Good luck, Lenka

[jchoucq]

Thanks a lot, lenka. Your expression is the correct one.

Moreover, By using the sort tab and the expression to sort in each dimension i get the right sorting.

Johann

[#4]

Do you have any hint for eralising the same, but in a line chart?

2 dimensions

Date

Sales Group

1 expression

sum(Quantity)

I would like the chart to look like, besides a line for each SG, a line on top which is the sum of all the quantity of each SG.

Thank you!