226-2011: LAG Function Combined with Conditional …

STEP 1: SORT THE DATA The first and most critical step is to correctly sort the data based on the variables that the LAG function will evaluate.

  First, With, Functions, Combined, Conditional, Lag function combined with conditional