Using pivot Variables in namedSet

[Benny Bürger]

Hi,

is it somehow possible to use a pivot variable in a named set?

Example: In the HoleFoods Sales cube I created a pivot variable selectedYear. (value is e.g. [now-3])

There is a named set which has the expression: DateOfSale.YearSold.[NOW]

Instead of NOW I want to use my pivot variable, thu the expression should be something like this:

DateOfSale.YearSold.$variable.selectedYear

What is the correct syntax to do this? (The above expression works when set as an MDX-expression under options)

Tia,

Benny