Compare 2 rows and show only rows with difference

[ashishpalkar]

Hi There

I have following data , I want to compare 2 immediate rows and show only those rows which has difference in Qty.

Dim:

LOAD *

INLINE [

  ID, Qty, Version

  1, 400, 1

  1, 400, 2

  1, 500, 3

  1, 600, 4

  2, 600, 2

  2, 700, 3

  2, 500, 4

];

Report Output should look like below:

id	oldqty	newqty	oldversion	newversion	Difference
1	400	500	2	3	100
1	500	600	3	4	100
2	600	700	2	3	100
2	700	500	3	4	-200

Can you please suggest something?

I tried with Above function.

thanks in advance.

[sunny_talwar]

Check this