#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)
Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, the data for the first quarter of 2020 is missing. When the data of this quarter is used to calculate LRR, skip...
