Line chart with two different years

[Shamar]

Hello Gurus !!!.

The below requirement was posted in this forum but there is no solution for this . Now i have the same requirement. Please suggest

I am trying to create a line chart which shows line charts for a specific measure for the current year and previous year (one line for current, another for previous). The x axis should show months. I am working with a dimensional model which does not have months independent of the year. The best I have is month/year. In this situation is it possible to create the kind of chart that I want in report studio(without making changes to the model in FM).

Thanks
Shamar

[ww55d]

in a subsequent query or component, could you parse out the month from the month-year? Same with the year?


example:
month = left(month-year,2)
year = right(month-year,4)