I have YearMonth and LoanKey as a Dimensions.I want to calculate default loans, and the formula is to check if a customer had made 3 consecutive payments in the last 3 months and if missed the 4th payment, then its a default.
In detail: If a cusotmer paid in the YearMonths 2011-03, 2011-04, 2011-05, 2011-06 (Works Normally)
Customer paid in the YearMonths 2011-03, 2011-04,2011-05, (This is a default as he dint pay in 2011-06) This check has to be done across all the months and then get the status in that YearMonth.
