Hi,
I need to accumulate the price for number of months available. I have used "( SUM(price)*flag))"in the expression and used the in-built modifier for accumulation . I need a flat line when price is '0',so that is the reason I have used flag.
Suppose we have data till month 5,then accumulatio will happen till month 5 and from month 6 it will be a flat line.
When I select month 7, accumulation is happening till month 6 instead of month 5 .
Accumulation is working fine in a table but not in the line chart.
Any suggestions here please.