7.10 Calculate using adjacent row/interval when data of the same group is continuous (link relative ratio and YOY)
Here below is an annual and quarterly sales data table:
Now we want to calculate LRR and YOY (calculate in cell D1):
A2: Calculate LRR, [-1] represents the previous row.
A3: Group by Year.
A4: Calculate YOY. The symbol ~ represents the current member in the loop function, and # represents the sequence number of current member in loop function.