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)