Dynamic Ageing

Hello, I am actually working on an AR ageing report. My data model is as follows: I have a AR transaction table with the amount, with a Date filed related to a calendar table. So far, I have manag...