13 months rolling with previous year comparison graph

[#1]

Hi,

I want to have a graph showing current year with previous year lines one on top of each other. This would look similar to this:

This works fine because I have a right function over my periods. Periods are defined as a XXXXMM string (this is how it is defined in the DB). Now, if I want to have a 13 months rolling, one months would be repeated and the data summed together, which is wrong. On the other hand, if we leave the full string, we won't be able to have the two lines above each other. Anyone out there with an idea?

Thanks and regards!

[marcel_olmo]

Thanks John, now it worked nice.

Cheers!!

[#3]

Hi John Witherspoon

Thanks for your solution it helped me also, here one more request from my side , in the same attached application I want to see a bar chart with last 13 months Variance with its Previous year same month how do I do this, could you please help me on this.

Regards

John

[darrinturner]

Hi, does anyone have an example of this solution. The attached does not load.