I have a WRS line graph with a measure on the y axis and months on the x-axis. However, the month category contains short names for months: JAN, FEB, MAR, etc. As a result, my x-axis values are sorted alphabetically.
In my report I have also a month number available for sorting, but I'm not allowed to put more than 1 object on the x-axis.
Can anyone tell me how to sort the months based on month number?