Hi Aditya,
possible solution to this is as follows:
1. Rank your main table by one or combination of columns to get Ranks 1,2,3 etc.
2.Create Custom SQL expression in which you can JOIN that main table to itself on the RANK column you just created but with offset:
SELECT * FROM TABLE A
JOIN TABLE A
ON A.RANK = A.RANK-1
This way you create a table where every row will have access to information from previous row. Of course adjust the query to your liking and don't necessary use SELECT * 🙂 Hope it helps!
Regards,
Michael Becker
qbeeq.pl
