DayEnd | Reorder | SalesDayInventory | Quantity | DayStart |
---|
39 | 0 | 39 | 25 | 64 |
64 | 54 | 10 | 65 | 75 |
75 | 65 | 10 | 8 | 18 |
Above is the output of the expected data. From the second row of DayEnd, I need to take the value of the previous row of the DayStart.How do I do that.If you observe the values of DayEnd, it would have the data of the previous row value of the DayStart.