Hi All,

I have a set of Data which includes thousands of rows like those listed below:

Case ID Summary Create date Subscriber ID
HD0000000576495 CR: Compliments 4/01/2011 52064730
HD0000000576780 CR: Consultation 4/01/2011 64465750
HD0000000576730 CR: Consultation 4/01/2011 50355684
HD0000000576763 CR: Customer Issue (direct) 4/01/2011 74880147
HD0000000576702 CR: Escalation 7/01/2011 50355684

I wish to be able to see if a membership has done anything apart from CR: Consultation after the first instance of CR:Consultation for that membersip number? For example i wish to see if a member has had to escalate (CR: Escalation) after already having had a consultation (CR: Consultation).


Guideance with this one would be most appreciated.

thanks,

Brent