I am trying to use the peek function to sustract the previous value without success.
What I would like to do is obtain the value from the expected value column. However, for the third line I am getting a 1 (6-5) instead of getting the first value of the second Field 1=2, as i understand that I am missing an aggregation by Field1 or something like that
The query I am using
Value-Peek(Value)) as ExpectedValue,
order by Field1 asc