I have airline ticket data that contains exchanges. The exchanges reference the preceding ticket in the Originating Ticket column. In this example, Tix1 is the original first ticket, Tix2-5 are exchanges, and Tix5 is the most recent or current ticket. The requirement is to aggregate the $ for these up to the most recent ticket #, Tix5. Any wisdom on how to accomplish this? THANKS!
