Liquidation Curve - Days Past Due

[#1]

Good afternoon,

I am having a bit of a problem trying to figure out how to put create a liquidation curve. Basically what I want is an x axis with Days Past Due from 1 to 180, a y axis with % paid of total. It should look like this:

I want to group by deposit month, so if I have January deposits, once all have come due (all come due in 30 days max) I want to start calculating CAPITAL OUT/CAPITAL IN. I have created a DaysPastDue variable to use as Dimension but am have trouble with how to create an expression that would do this.

I have a DUEDATE, CAPITAL OUT, PAYMENT IN variable which will obviously be of use...could anyone give me a hand?

Many thanks!

Please, any help appreciated!