Optimize a calculated dimension

[Anonymous]

Hello, I have a dimension containing a if but the response times are very long because volumes are important. Do you have solutions to optimize?
Thank you

Aggr(If(Rank(Sum([Ca Produit HT])) < 2, [Super Famille]), [Code Client],[Super Famille])

[vishsaggi]

I have not tried but just check if this works?

= Aggr(Only({< [Super Famille] = {"= Rank(Sum([Ca Produit HT])) < 2 " } [Super Famille]), [Code Client],[Super Famille])

[sunny_talwar]

May be don't use a calculated dimension, but use a set analysis in your expression.

[Anonymous]

thanks

I tried to change by an expression like that but I have some bizarre cases in yellow.The function does not match with rank

if ( aggr(Max(total(turnover)),customer_code)>0,1,0)

Do you know why?

thanks for your help

[Anonymous]

Application example

thanks

[passionate]

If you want to show top 2 values why don't you try dimension limit.

[sunny_talwar · Accepted solution]

May be this?

Count(DISTINCT Aggr(If(Rank(Sum(turnover)) < 2, customer_code), customer_code, family))

[Anonymous]

wonderful

thanks you very much for your help