Inter Records Analysis

[#1]

Hello,

I have a table as follow: TicketID, Sales.

The tickets are ordered by ticketID ascending.

I would like to create a chart (straight table) which shows you the ticketid and its sales. However, the condition is: If the next ticket's sales is larger than $100. How can I create this inter-record expression? Will set-analysis help in this case?

Thanks...

[#2]

Thanks