Get Rangesum to work in Line Chart

[adontchosgarnet]

I have an expression in a pivot table that works perfectly.  However, it does not work in a line graph.  Anyone know how to fix this?

The expression is:  

Rangesum(Before(Sum({<[Payment_vs_ChargeOff]={">=0"}>}Transaction_Amount),0,ColumnNo(TOTAL)))

My x-axis (Payment_vs_ChargeOff) is a number months past a certain point and my dimenson is the ChargeOff Year.  So, each line represents a year and each point on the line is the number of months past the charge off date.

My y-axis is the cumulative total of the transaction amount.

[Kushal_Chawda · Accepted solution]

@adontchosgarnet  Before() and ColumnNo() functions are specific to pivot table, it will not work in any other charts except pivot table. You can use, above() or below() with rowno(). Probably like below. You can change it to below accordingly

Rangesum(above(Sum({<[Payment_vs_ChargeOff]={">=0"}>}Transaction_Amount),0,RowNo(TOTAL)))

[adontchosgarnet]

You sir, are a steely-eyed missile man!  Thank you!