Prior Quarter Logic for First 3 months of Current Year Quarter 1
Prior Quarter Logic for First 3 months of Current Year Quarter 1.
We are working on a Grid to show up in a Report Containing Value for
Current Month, Current Qtr, e.g: Feb, Q1, 2022
Prior Qtr, Prior Year, e.g Q4, 2021
We are able to settle down the Year value with relative function using offset and substitution variables.
But we need a solution for Prior Qtr.
Approach # 1,
Display all Q1, Q2, Q3, Q4 columns for prior year and hide Q1, Q2, Q3 and display Q4, when period is selected as Jan, Feb, Mar
For rest of the period, Relative function helps