SAC Planning cross Tab to show actual of current year

[vijaykumar108]

Hi All

we built story on planning model consists of versions actual,budget,forecast etc.

our requirement in report we have to show in columns actuals of previous year and actuals of current year(YTD), budget or forecast selected by user depend up on the planning year selected.

ex:if user selects planning year as 2022 and version budget,actuals.

then we have to show actuals of 2022,2021.budget of 2022.

we are using crosstab and for actual am giving lookback oneyear and lookahead am selecting budget .

we are able to bring actuals of 2021 and budget 2022.(by using above look back and look ahead).

How to bring actuals of current year (2022)?

Please provide us your inputs.

Thanks,

Vijay

+91-9704539878

[vijaykumar108]

Hi Nikhil ,

Thanks for your inputs.

I am trying restricted measure approach.

Calculated column am getting ,but its not satisfying our requirement.

Depend up on year selection it should reflect in planning cycle and actual should come for current year and previous year.

ex:if date selected as 2023 and forecast is selected for version in input control.

report should give forecast for 2023 , actuals for 2022and 2023.

attached screenshot for reference.

Thanks,

Vijay

9704539878

[N1kh1l]

vijaykumar108

Cross Tab might not work in your case. Either go for Restricted Measure Approach or Advanced Filtering approach. Refer to the blog below for some guidance.

https://blogs.sap.com/2021/03/19/sap-analytics-cloud-for-planning-leveraging-stories/

Hope it helps.

Please accept/upvote if it helps.

Nikhil