Analysis for office: Dynamically retrieve prior period

[Robert_Jan_Bron]

Hello,

We ar using AfO reports on Group reporting. What we want is reports that automatically show 2 collumns of data: The current period (as selected by the user in the prompts) and the prior priod for comparison. How can we create that without having to select the two periods every time?

And idealy we set the collumns up as separate measures so we can create a calculated measure to calculate the variance.

Kind regards,

Robert jan

[g11600]

You would need to create custom CDS view for this - and it's not trivial.

If you're on Cloud, or can wait for on-premise 2022 release - it will be available 'out of the box' in report booklet functionality. See

Review Booklet for Group Financial Statements | SAP Blogs