Rolling 12 Month Comparison

[samvile18]

Hi all,

I know this can be done and I'm really close to it, I just can't seem to get the syntax quite right. 

I have data laid out like this:

I need to create a graph which shows the last 12 months rolling whilst comparing this years data with last years. Does that make sense?

So a monthly bar chart showing each months variance to the year before, across a rolling 12 months. 

Any help would be greatly appreciated - I've got the comparison bit done, I think - it's the rolling 12 months I'm struggling with. 

[MeehyeOh · Accepted solution]

Hi , @samvile18

I think can meet the requirements by using Set analysis and adding two scales to the bar chart with Month as dimension. 

eg.