Skip to Content
0
Sep 08, 2023 at 11:10 AM

SAP Analytics cloud template creation

119 Views

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

image.png

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

image.png

image.png

Could you please help me to build this tempalte?

Regards,

Mahadev

Attachments

image.png (56.9 kB)
image.png (107.0 kB)
image.png (107.9 kB)