add value on row above on dashboard

[andywil456]

I'm trying to create a visual that will show a running balance. Here is a screenshot summarizing the data showing the balance for each category, but i really cannot find a solution how to create a running balance. 

I have tried creating a table and using the following fomula such as 

cashflow = CALCULATE(sum('cust and supplier cashflow'[Amount_1]),FILTER('cust and supplier cashflow',CONTAINS('master payment category','master payment category'[index],'cust and supplier cashflow'[index]))).

This only puts the total amount of £69117.74 on each payment category line.