Skip to Content

SAP Analytics Cloud: Rolling 12 months Year on Year Variance

So we had a request to have a chart that shows rolling 12 months. (currently from August 2020 back to August 2019)

This was fairly simple to do using a dynamic filter to look back 12 months from current period.

The difficulty I'm having is that anything outside of that range to all intents and purposes does not exist. So I can do a month to month variance (although the variance for August 2019 shows as "-") but if I wanted to compare July 2020 to July 2019 I get "-" as well when I'm doing a variance to previous year.

Is there a better way to do rolling 12 months with a year on year variance?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.