IBM Business Analytics

Hi Guys,
there are some requirements for the Cognos report,
Need to display data as quarterly 
Example:  user enters date as 03-31-2023
then expecting the below output:                     
Dimension                      Q2-2022  Q3-2022  Q4-2022  Q1-2023
Great Out Door sale              50            100          30           25
Equipments                           20            30            10          30

basically, rolling 12 months data should be displayed as quarterly.
it is a Relation List report, no cubes or DQM or OLAP are involved.

if it's cube-based I would have handled it easily, it's a relational report so I think need to use some date functions like _add_months or _add_years functions or something to handle previous dates, need help on this guys.

Thanks!!