How to calculate rolling period calculation based on FiscalYearPeriod in CDS views

We have one requirement to calculate Rolling Period (R2/R3/R12) based on range of Fiscal year Period and have to sum up based on R2/R3/R12.

Example. FiscalyearPeriod range: 002.2022 - 008.2022

FiscalyearPeriod GC Amount R2 R3

002.2022 10 10 10

003.2022 20 30 30

004.2022 30 50 60

005.2022 40 80 90

006.2022 50 90 120

..

We can find out the amount for each period. But while going to sum for (Amount of curre period+Amoung for Prev Period), it's not happening. Means we are not getting the added values rather for each period amount is displaying only.

If you provide any idea or solution to resolve then it will be much appreciated.

Hoping for your response here.

Thanks in Advance,

Regards,

Anu