Hi Guru's
I have the below data

My requirement is below
If you are in 1st month of current Qtr then consider only the first of month of previous qtr. (Ex: in current qtr Q2/2023, we are in 1st month I.e. JAN. then previous Qtr revenue should be: Q1/2023 OCT month only)
If you are in 2nd month of current qtr then consider 1&2 month of previous qtr. (Ex: in current qtr Q2/2023, if we are in 2nd month I.e. FEB. then previous Qtr revenue should be: OCT & NOV months of Q1/2023 data)
If you are in 3rd month of current qtr then consider whole previous qtr. (Ex: in current qtr Q2/2023, if we are in 3rd month I.e. MAR. then previous Qtr revenue should be: OCT & NOV & DEC - All months of Q1/2023 data)
Can any one help me how to achieve it.