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 ))
![fsilva1_1-1655159437540.png fsilva1_1-1655159437540.png](/t5/image/serverpage/image-id/81654iB897EBAAA2C07263/image-size/medium?v=v2&px=400)
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
![fsilva1_2-1655159720418.png fsilva1_2-1655159720418.png](/t5/image/serverpage/image-id/81655i607B4499B6800482/image-size/medium?v=v2&px=400)