Instead of looking at who the new customers are, I would like to identify which customers have been churned out in the next period. So looking for a function that works opposite to the previous() function.
I'm looking to do something very similar. I have a field called 'FlowDirection'. If the record ahead has a value of 'Backwatrds' I want the field I'm creating to have 'Y' else 'N'. I don't quite see how I can fit this into the logic provided thus far.