Skip to Content
Aug 19, 2020 at 12:14 PM

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?