@CarlyGoldberg welcome to the KNIME forum.
In KNIME you have the Lag Column which can read values from preceding rows. You will find examples how to use this column below the description or on the KNIME hub.
Also there is this discussion:
You might also provide us with an example (can be dummy data) to demonstrate what you want to do.