rolling back Qtrs in calc script
Summaryrolling back Qtrs in calc script
I have requirement where my calc need to use data from previous Qtr if we are in current Qtr
for Ex1: if we are Jan-2018 or feb-2018 or Mar-2018 which is Qtr1-2018 then I need to pick the data from Qtr4-2017
Ex2: if we are in Apr-2018 or may-2018 or jun-2018 which is Qtr2 then I need to pick data from Qtr1-2018
how can I do it??