How to get cumulative data monthly

[Luffy20]

Hi All,

MonthYear	Sum(Monthly Cost)	Rangesum(Above(sum([Monthly Cost), 0, RowNo()))
May-24	$4,861,903.95	$4,861,903.95
Jun-24	$9,095,384.81	$13,957,288.76
Jul-24	$12,488,570.90	$26,445,859.65
Aug-24	$16,793,566.49	$43,239,426.14
Sep-24	$22,501,672.81	$65,741,098.95
Oct-24	$28,692,063.54	$94,433,162.49

I have created the cumulative data but when i am selecting june in month filter it is getting $9,095,384.81 but i want to show the cummulative value of june month i.e.,$13,957,288.76, can you guys help me with this

[marcus_sommer]

You need to ignore the selection within the expression, maybe in this way:

Rangesum(Above(sum({< MonthYear >} [Monthly Cost), 0, RowNo()))

and an additionally step may be to add a boolean filter to respect the selection in regard to the object again, for example by multiplying the above with:

sign(count(MonthYear))

[Kushal_Chawda · Accepted solution]

@Luffy20  If your MonthYear is formatted NUMERIC, try below

=sum(aggr(rangesum(above(Sum({<MonthYear>}Cost),0,RowNo(total))),(MonthYear,(NUMERIC))))

[Luffy20]

Thanks that wokred