Cumulative Sum

senciucserban — Mon, 19 Mar 2018 00:11:13 GMT

Hello,

I try to make a cumulative graph, I use: Rangesum( Above(Sum(quantity), 0, RowNo())) everything works fine.

But When I try to add a new dimension I have a problem:

Also I try to use: Aggr(Rangesum( Above(Sum(quantity), 0, RowNo())), week)

I want to make graph to be like the 1st graph:

Dimenstion are: week, name

Measure are: quantity

Thanks

Re: Cumulative Sum

senciucserban — Mon, 19 Mar 2018 10:21:34 GMT

I solve with: Aggr(Rangesum(Above(Sum(quantity), 0, RowNo())), name, (week, (NUMERIC, DESCENDING)))