Top ten selection

[JoseGarcia]

Hi everyone, 

trying to set a button that automatically will select my top ten Risk current values.
Using formula below but not working? 

Can anyone help?

=if(aggr(rank(sum(currentImpactValue)), Risk_ID)<=10, sum(currentImpactValue))

Thanks a million!

Jose

[agigliotti · Accepted solution]

you could use the below calculated dimension:

=aggr( if( rank( sum(currentImpactValue) ) <= 10, Risk_ID), Risk_ID)

it'll give you the top 10 Risk_ID by currentImpactValue.

if you want to automatically select those values of Risk_ID dimension you can create a bookmark as 

=rank( sum(currentImpactValue) ) <= 10

and apply it as a button action.

i hope it can helps.

[JoseGarcia]

thanks a million!!!
it worked 

jose

[seemawadekar]

Hi @agigliotti ,

Thanks for your answer. 

I have couple of filters - region and manager. Its works for few values of the filters but not for others. 

Can you help me resolve it?

Appreciate your help. 

[agigliotti]

Hi @seemawadekar ,

Please add more details about your request.

Best Regards