I am trying to find the date of the second occurrence of a transaction (and then subsequently the third, forth, etc).
For example, a customer purchases various products on his first visit,
on the 31/03/2017
But then the same customer purchases Product 2 on the 30/04/2017.
In a table that has the customer number, the transaction date, and the product, how do I get the subsequent sales date shown on the current sales record.
In the end, I want to be able to see for each record, when the next sale was of this product for this customer.
|Customer||Product||Sales Date||Next Sales Date|
Is this possible? So I need this to look at both the customer number and the product? Potentially, if I wanted to find this by location as well, could that be added in rather simply with an additional filter or condition?