Use Expression Label in Calculated dimension

[guyvermeiren]

Hello,

Can I use the expression label in the formula of a calculated dimension ??

Let's say that I calculated the rank in the expression with label "Position". Can I use the name "Position" then in a calculated dimension ?

Thanks

Kind regards,

Guy

[boorgura]

I dont think you can use the label direcly.

But, you can use the same calculation using aggregation function.

[guyvermeiren]

Thanks Rocky,

But the goal of my question is the next. I think this is really difficult.

I want to limit my table to a Top 10 what isn't difficult but I want a top 10 for my customers who are advancing the most and had a turnover last year that was above a certain limit.

These are the two expressions that I try to combine in my calculated dimension but how do I say in my formula that I first want to limit the list to customers with a certain turnover and then only show the top 10 (by rank and "Suppress when value is Null" ).

Expression 1: limit turnover

Expression 2: Rank on evolution

=If(aggr(sum({$<[COPA.Fiscal Year]= {$(=max([Calendar.Year])-1)},COPA.Period= {'*'} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR]), [GeneralPayerMasterData.Customer Name&Code])>15000,[GeneralPayerMasterData.Customer Name&Code],null())

=If(aggr(rank(( Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]))} , [COPA.Period]= {">$(=min([Calendar.Month])-1)<$(=max([Calendar.Month])+1)"} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR] )/ Sum( {$<[COPA.Fiscal Year]= {$(=max([Calendar.Year]-1))} , [COPA.Period]= {">$(=min([Calendar.Month])-1)<$(=max([Calendar.Month])+1)"} >} [COPA.Niko Act Gross Sales incl Projects Rebates NL/FR] ) )-1),[GeneralPayerMasterData.Customer Name&Code])<=10, [GeneralPayerMasterData.Customer Name&Code],Null())

It would be great if someone could help me.

Thanks

Kind regards,

Guy