1 Reply Latest reply: Mar 19, 2018 6:21 AM by Serban Senciuc RSS

    Cumulative Sum

    Serban Senciuc

      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