Accumulation

[smilingjohn]

Hi Expertise 

first table show the sum of total products sold every week , and the second table show the accumulation of the products weeks by adding previous weeks total to current week as shown in the screenshot attached .
If you look at second table 13-jan-2019 for accumulation is not showing anything because there is no data for it .
My requirement is to show 7 products there if there is no data it should show the accumulation of previous week.
I am not getting this can you expertise please help with this .

I am using the below expression to achieve the accumulation of products .

Expression:
RangeSum(before(total count({Severity={'Sev 1','Sev 2','Sev 3','Sev 4'},year={'>2018'}>}Prodcut),0, ColumnNo(total)))

Thanks in Advance 

[sunny_talwar]

Can you try this

RangeSum(Before(TOTAL Count({<Severity = {'Sev 1','Sev 2','Sev 3','Sev 4'}, year = {'>2018'}>} Prodcut) + Sum(0), 0, ColumnNo(TOTAL)))

[sunny_talwar]

Also, you want to see 4 or 7? The accumulation should be 4 based on 3+1+0, isn't it?

[smilingjohn]

Its should be 7 and also your given expression  is not working. 

RangeSum(Before(TOTAL Count({<Severity = {'Sev 1','Sev 2','Sev 3','Sev 4'}, year = {'>2018'}>} Prodcut) + Sum(0), 0, ColumnNo(TOTAL)))

[sunny_talwar]

What is the reason behind seeing 7 and not 4?