Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
May be this?
Count(DISTINCT Aggr(If(Rank(Sum(turnover)) < 2, customer_code), customer_code, family))
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])
May be don't use a calculated dimension, but use a set analysis in your expression.
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
Application example
thanks
If you want to show top 2 values why don't you try dimension limit.
May be this?
Count(DISTINCT Aggr(If(Rank(Sum(turnover)) < 2, customer_code), customer_code, family))
wonderful
thanks you very much for your help