I have to develop below crosstab report.
Outstanding Claims Current 1 month old 2 months old 3 months & older Total Outstanding
average 2008 248 87 46 19 400
average 2009 216 99 56 25 395
average 2010 145 62 15 3 225
average 2011 123 60 11 2 196
average 2012 103 45 8 2 157
current - average of total number of claim which are open for 0-30 days
Business logic for the report:
Claim Age = Claim last Updated Date – Claim Filed on Date
Claim Filed on date should be before Report run date.
Claims which are open for 0-30 days will be under Current Column,
Claims which are open for 31-60 days will be under 1 Month old.
Claims which are open for 61-90 days will be under 2 Months old.
Claims which are open more than 91 days will be under 3 Months & older.
Report Run Date is 25th of every month.
I have to calculate total number of claims every month for each section (current,1 month older....)
Can anybody help how to do this?