Use set analysis in Dimension

[Theo_Westseit]

Hello Guys,

thanks to Mr. Cronström, i was able to got this set analysis working:

Sum({$<Month={'$(=Num(Month(Today()-35),'00'))'}>} SALES_40 )

Now i want to use it in a dimension. How do i need to change it?
On the particular Dimension i always want to display the Sales of the month minus 35days

[hic]

You can use a set expression in a dimension using the Aggr() function:

=Aggr(Only({setExpression} Field),Field)

but this is VERY rarely what you want to do. Also, the Aggr() function is slow.

No, I suggest using the set expression in your measure. If you do, and uncheck "Include null values", the dimension will automatically show the values corresponding to the set expression.