Cumulative Sum by year - Sorting AGGR(RANGESUM(ABOVE()))

[fsilva1]

Hi guys,

I'm trying to do the cumulative by year, but when start a new year, is continue cumulating but I want to start a new cumulative when a new year start.

my expression:

aggr(rangesum(above(Sum( value),1,RowNo())),(year_month,NUMERIC))

I dont understand why, jan 2022 is not start a new cumulative, its keeping cumlating. Someome please help me?

The expected result is that in jan 2022, the value to third column be 996766,42 starting a new cumulative values

@sunny_talwar please help me

[vinieme12]

try as below

=aggr(rangesum(Above(sum(value),0,rowno())),YEARFIELD,YEARMONTHFIELD)

[fsilva1]

First of all thank you for your answer..

But not working

aggr(rangesum(below(sum({<period-={'$(=min({1}period))'}>}[value]),0,rowno())),period,period_2)