Full accumulation not working in chart?

[#1]

Hello all, 

I have a bar chart where I am trying to show accumulation of application testing status (Red, Amber or Green) over time. I noticed that the December bar was shorter than the November bar;  upon review of the underlying data, it appears that if there is a month where a value doesn't exist, it doesn't show the previous month at all.  Is there a way to do full accumulation for two dimensions so that I can see the full total at the end of the year?  Thanks in advance.

[#2]

Hi Lisana,

If you have two or more dimension to get the running total try this formula

rangesum(above(Expression,0,rowno()))

Thanks

AJ

[MK_QSL]

= RangeSum(Above(SUM(Sales),0,RowNo()))

or

=RangeSum(ABOVE(TOTAL SUM(Sales), 0, RowNo(TOTAL)))

Make sure that under presentation tab, you have untick the Suppress Zero-Values option

[#4]

I've tried both of these, which look fine in a straight table, but when I convert to a chart it doubles, so I end up with twice as many.

[#5]

Possible to attach a sample