Showing Multiple Years on Trend Panel

[kpiforge]

I am trying to recreate this chart:

I have gotten to this point:

But anytime I try to add the year column, it tells me this:

I want to be able to show a different trend line for each year.

[yosiasz]

Do you need monthid? And is this a time series chart?

[kpiforge]

It is a trend chart. I need the month_id because that is my x-axis.

[yosiasz]

you need to pivot your data

resulting in

[grant2]

Another possibly interesting-and-related post here.