Historical Debt Trend

Dear All   Pls your help. I need to know how I can generate a historical debt trend by week and year. For example, if we're in week 1, I need to calculate the total and past-due debt for that wee...