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

    Cumulative Sum

    Serban Senciuc


      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