cumulative by year, above only first year

[fsilva1]

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