Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])