Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
Also, you want to see 4 or 7? The accumulation should be 4 based on 3+1+0, isn't it?
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)))
What is the reason behind seeing 7 and not 4?