Creating a custom column that calculates the previous row value by previous hour, date, & store

Hi,    I'm really struggling with this. I'm trying to create a custom column that calculate the previous row Total Consumed (w/o Cancellations) column. The Total Consumed (w/o Cancellations) column ...