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
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)