How to get a Text Variable for a Replacement Path Variable for Calmonth
I have a report based on 12 rolling months, based on 0CALMONTH. The user enters the 0CALMONTH once, and then can see two key figure columns, both rolling out for 12 months, and both of these key figure columns are based on the same month that was initally input by the user.
I did this creating 24 key figure Selections, and for 12 of these selections (ie the first key figure) I used an offset (-1, -2 etc) for the variable which the user directly input the date into. For the other 12 selections (the other key figure) I used a replacement path variable, referencing the original user input variable, and offsetting this.
This works fine for the data itself, but now I want text variables displaying the months. Creating a text variable based on the user input 0CALMONTH variable just results in the very first entry being correct - ie the one which the user input.
Do I need to create a customer exit variable for this? If so, how would I go about this?
Please let me know if my question doesn't make any sense, and thanks for your help...