Prior Quarter Logic for First 3 months of Current Year Quarter 1

Summary:

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

Content (required):

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