Please assist? I have gone through numerous SDN threads relating to the following, but could not find a solution for my problem.
1) User wants to see 16 weeks data in columns, each week in own column. I have created a structure for each week with offsets 0 to -16, 0 to -15 and so on to display data. User wants to '0' display even if no data was loaded for a certain week, thus the structure. The data is displayed for 16 weeks. Now I want to replace it with calendar week text. (I have used week 12 to test text variable. week 12 should be displayed as 'example' 2008/42)
2) There are no calweek text variables available for selection, so I created a new one as 'replacement path', characteristic "Calendar year/week" and 'replace variable with "Name (Text)".
2.1) The following is the result 12 &0DPM_WV1&. Not what I wanted.
Where am I going wrong?
Your assistance will as always, be appreciated.