Running Balance Line Chart

[BouwerVa]

I made the following line chart showing our daily LG. But I would like the line to increase with each days LG.

I add a Screenshot with the Line Chart and Dimension. The Chart is filtered for a Specific Month.

Here is my Formula:

RangeSum( Above( Sum(if(TTYPE = 'Lo' and TGROUPTYPE = 'Lo', CAPITAL)),0,RowNo() ) )

[BouwerVa]

It works perfectly within a table but as soon as I put it in a graph it doesn't work.