Dynamic Column Headings

Replacement path would only work if the key figures were restricted by a fiscal year variable with offsets. As I mentioned, the fiscal year is the same

I do not think you can do offsets with Text variables e.g &textvar&-1 will show up as 2004-1 not 2003 (the desired result)

mike

create three new selection with variable for year (value interval).

insert offset -1 and -2 for selection 2 and 3(right mouse on the variable)

alessandro

You can do this using text variables. Create a text variable, processing type is replacement path and the characteristic is 0FISCYEAR. Use this text variable in teh description of your column: Key figure > right click > Edit > you see the description box and next to that is the button from where you can create / select a text variable. When you use the text variable in the description, you will see something like:

Sales &FYTEXT&, where FYTEXT would be the name of your text variable.

Hope this helps...

mike,

naturally in the definition of new selection you must insert Sales - 'textvariable'

alessandro

I was thinking of that option as a last resort where in step 2 of the exit I derive the other text variables based on user input of one text variable. I was hoping there was a more elegant solution.