Range Sum - can't get my expression to work

[zagzebski]

THis should be simple but obviously doing something wrong.  I want Expression 2 to accumulate on expression 1 - it should look like "What I want" column but all it is doing is returning the same number for the current row.

Expression 1: SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL])

Expression 2: RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo()))

Month/Year	Expression 1	Expression 2 (not working as expected)	What I want
Jan-15	4,500.00	4,500.00	4,500.00
Feb-15	4,500.00	4,500.00	9,000.00
Mar-15	24,568.81	24,568.81	33,568.81
Apr-15	4,500.00	4,500.00	38,068.81
May-15	4,500.00	4,500.00	42,568.81
Jun-15	1,991.79	1,991.79	44,560.60
Jul-15	-	-	44,560.60
Aug-15	-	-	44,560.60

Zag

[marcus_sommer]

Try:

RangeSum(Above(SUM({<[Tran Desc]={'Payroll','payroll'}>}[Amount GL]),0,RowNo(TOTAL)))

- Marcus

[MK_QSL]

Check enclosed file..

[evan_kurowski]

And don't forget if your chart is a straight table, that you have the 'Accumulation' options.