Limitation of dimension by custom expression

[SamuelHaag]

Hi guys,

is there a way or workaround to set the limitation of a dimension (fixed value) to an expression?

For example in my case the limitation of 50 is calculated for "Ergebnis 2 YTD" but I need it for "Sales":

Thank you very much!

Regards 

Samuel

[SamuelHaag · Accepted solution]

Hi guys,

I got a Solution for this by creating a new dimension:

=aggr(if(Rank(total Sum([SALES]),4)<=50, [MY DIMENSION FIELD]), [MY DIMENSION FIELD])