Dynamic dimension

[Anonymous]

Hi all,

In Master Items / Dimensions I have declared a dimension with this expression : =$(=max( YearDim ))

So the dimension has one single item: the greatest selected year .

I want to add to the dimension 2 more items : the smallest selected year, and the delta between the two years displayed.

Anyone could give a clue how to do that please? Thanks

[theglenndavid · Accepted solution]

I would suggest looking at the ValueList() function.

i.e. ValueList($(=max( YearDim )),$(=min( YearDim )), 'whatever value you want to add')