Calculate Year over Year data on a Chart

[#1]

Hi, I hope someone out there will be able to help me with this one, I'm really struggling. I've read numerous threads on here about YoY but cannot seem to find anything that fits with my requirements....

I'm trying to show Year over Year data alongside current year data on a chart. I can show the current year's data accurately with the following expression:

         =num(sum([UNIT.SALE_PRICE])/sum([UNIT.MARKET_PRICE]),'##.##%')

but then need to do the same expression but to show data for the previous year

Please help, thanks

[tresesco]

Not sure if understood right. If you take Year field as dimension and the expression as yours, doesn't it work? If you don't want all years, you can limit them using dimension limit, or, using set analysis.

[#3]

Hi, sorry, no, I've got month as the dimension, so that I can show the data on the chart by month, but I need to show the previous years stats too

[#4]

This is what I'm trying to create:

[tresesco]

See this blog post: Year-over-Year Comparisons