5 Replies Latest reply: Aug 9, 2018 9:46 AM by Laura Holland RSS

    Cumulative sum for months when no transaction in month

    Vivekanand Joshi



      I am trying to show cumulative sum over the months, but there are no transactions in some month. i still want to show total upto previous month though. in next month, if there is a transaction, the sum should be updated.


      For example, right now my chart looks like this :




      But I want to show 116 for the month of April and May as well. Then 167 for Month of June which is correct. Is this possible?


      The formula I am using for cumulative sum is :


      Aggr(RangeSum(Above(Sum(Qty_Ord), 0, RowNo())),Year,Month)