I am trying to identify patterns with regards to types of holidays taken from a DB of passengers. I have dates and destinations assigned to each passenger, but I want to be able to identify which destination was visited first, second, third etc in order to profile passengers by their booking path. For example:

 

Caribbean 1/2/2006

Norway     2/3/2008

Canada     3/4/2007

 

The pattern for this passenger is obviously Caribbean, Canada then Norway, but how can I get Crystal (XI) to identify this for me i.e. how can I get it to recognise the order of holidays from the date, so that I can then group passengers together by their booking path?

 

Or in perhaps simpler terms, how can I use Crystal to help me identify if one event has occurred before or after another?

 

Thank you in advance for your help.

 

Thank you for your reply though.