esProc Desktopesproc-desktop.hashnode.dev·Oct 31, 2024#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 this quarter directly, and u...10 likesexcelAdd a thoughtful commentNo comments yetBe the first to start the conversation.
