Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
senciucserban
Contributor II
Contributor II

Cumulative Sum

Hello,

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

Opera Snapshot_2018-03-19_020244_sbb-bi.jibecompany.com.png

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

Opera Snapshot_2018-03-19_020654_sbb-bi.jibecompany.com.png

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

1 Solution

Accepted Solutions
senciucserban
Contributor II
Contributor II
Author

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

View solution in original post

1 Reply
senciucserban
Contributor II
Contributor II
Author

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