Chart with Full Year LY and YTD This Year

[bweber]

I want to plot sales data on a chart.  I have this year and last year data however when I plot them, it will only show me the last year data up until the current month. 

So how can I chart the full year by month of LY values, and then the YTD values?

Thanks,

Brian

[pricter]

Are you using a cube or a relational model?

[bweber]

Relational.

Thanks,

Brian

[pricter]

Create a data item to calculate the month and place it on the x axis
Create a date item to hold the current year sales
for exaple
if (year=currentyear) then (sales) else (0)
Create a date item to hold the py sales