Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm tryng to do a cumulative table, where I need to use above to shift one month_year, and I need to accumulate this values. The problem is, I need to do this by year, for 01/01/2022 the value doesn't can be cumulate, so start values again with value = 55222910,65 and not 0 or cumulative for last year.
my measure:
aggr(
rangesum(above(Sum(aggr(sum(value_fat),(Year_2,NUMERIC,ASCENDING ),(year_month,NUMERIC,ASCENDING ))),1,RowNo()))
,(Year_2,NUMERIC,ASCENDING ),(year_month,NUMERIC,ASCENDING ))
The correct is like in Power BI, I need to reproduce this in qliksense
Please not consider the format value in %, the numbers are absolute, the first line (blank) is the first month_year 01/09/2021 like qliksense, the problem like as said is in the first month on 01/01/2022