SAP Analytics cloud template creation

[N1kh1l]

HI All,I have created a forecast layout template but in the forecast layout I'm able to achieve the below template layout.Below is the my requirement -For exampleSelection - FY2023If I select FY2023 then ACTUAL should be for prior year FY 2022.Total and it should be group and un group features by month wise.
The Plan category has FY 2023.Total and should be group and un group features by month wise .The FC1 category forecast category - It has ACTUAL and FC1, ACTUAL is closed month data and FC has forecast data.
Columns D to O and Q to AB grouped in the screenshot
Below is the report layout

After un grouping P and AC columns, Below is the layout of template -

Could you please help me to build this tempalte?

Regards,

Mahadev

[N1kh1l]

mahadev_9

Where are you trying to create this template? SAC Add-in or Stories ?

-Nikhil

[vishalakshmi]

Hello Mahadev,

use the dimension setting:

Ref: https://answers.sap.com/questions/13231300/how-to-group-dates-into-month-dimensionkey-figure.html

Thanks,

Lakshmi.

[mahadev_9]

Thanks Lakshami.

My requirement is when I select the current year then ACTUAL should be for the prior year. Plan data should be shown for the selected year.Forecast category should have some actual data and some forecast period and it should be a group and ungroup feature.
Could you please refer my above three screenshots.
Regards,Mahadev