Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this