Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All ,
Iam using the below calculted dimesion to get top 5 clients
=if(aggr(rank(count(Key)),Client)<=5,Client)
How do i use this dimension to show bottom 5 clients
Thanks in advance
Try if(aggr(rank(count(Key)),Client)<=5,(Client,(Numeric,Ascending)))
Hi Jerry
this is not wotking
May be just put minus before your measure count(), like: =if(aggr(rank(-count(Key)),Client)<=5,Client)
H tresseco
its not working.. i tired this one also
i want ti show a bar chart with bottom 5 clients
and one more bar chart with top 5 client
Could you post a sample app and explain your expected output there?
So, try to create a variable V_max with :
=max(aggr(rank(count(Key)),Client))-5
And use it in your formula :
=if(aggr(rank(count(Key)),Client)>=V_max,Client)
As an alternative, just display the Client in the dimension. For the first expression, use Rank(count(Key)) and hide that column on the presentation tab. On the "dimension limits" tab, restrict the values to the largest/smallest 5 and uncheck the "show others" option.
Hey John,
Try below expression.
For Bottom 3
=IF(Aggr(Rank(-1*sum(Sales),1,1),(Region,(NUMERIC, ASCENDING)))<=3,Region)
For Top 3
=IF(Aggr(Rank(1*sum(Sales),1,1),(Region,(NUMERIC, ASCENDING)))<=3,Region) @
Try this,
=AGGR(IF(Rank(-Sum(Sales),4)<=5,Period),Period)