SAP Analytics Cloud Planning Report

[pragnya_m]

Hi Team,

I have a below requirement where i need to show quantity, sales, cost & Gross profit in a report.

For ex Plan year is 2022 here, so i have to always display full year plan and based on user selection have to display Plan, Actual and prior year actuals data by period (Dec) as below.

GL Account range for Quantity is 50000000 , sales GL range is 40000000 to 49999999 & cost GL range is 50000000 to 59999999. Can we achieve below report in SAP Analytic cloud planning?

[Sowmiya_Chinnappan]

Hello pragnya.m,

Hope we could achieve this by doing cross calculations,

Create Cross Restricted Measure for PLAN, ACTUAL, PRIORYEAR.

Please check and let me if it helps for you.
Thanks,
sowmiya