Hi,
I'm trying to create a YOY sales graph, but I'm having trouble because our subscription sales start in March (before our fiscal year that starts in July) and singles continue to be sold through May of the following year. I can get it to show the lines separate from each other (see below), but I can't figure out how to get them to not consider the year so that they'll lay on top of each other. Is that possible? Thanks for your help.
Hi Kanani,
Could you try changing your X-Axis to Calendar Month Sort value? I am thinking that, because you are using 'Months in Date', it is pulling each month from each year so splitting up your lines. If you use Calendar Month Sort (or something like it), it should only use 'one' April for all three years and overlay the lines.
Derrek,
Thanks for your comment. Unfortunately that doesn't work because it wants to put 01 January and 02 February first, because they are first in the calendar, but on the graph I am trying to make they should come after December. Adding more troubles is the fact that we continue selling tickets into March, April, May of the following year.