Line Chart with Year Over Year Comparison on Total Sales

[repetto74]

I would like to show a line chart with Year Over Year comparison of total sales per Month. Years are ranging from 2017 to 2018 and I have a calendar dimension with Year and Month.

How can I set the correct expression to do that?

Thanks,

Rick

[Wlad_Masi · Accepted solution]

Hi @repetto74 ,

It looks like this other posts "Multiple lines on line chart" and "How to create a multiple line chart of trending by time" may have the answer you are looking for.
Can you check it please?

[repetto74]

Thanks for the older references on this matter. I could find the correct syntax for this calculation 🙂

[Wlad_Masi]

@repetto74  Glad I could Help!