Skip to Content
0
Jan 11, 2023 at 02:04 PM

Difference of First month Current Quarter with First month Previous Quarter SAP BO

40 Views

Hi Guru's

I have the below data

image.png

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.

Attachments

image.png (23.6 kB)