Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

RANKX as calculated column based on column

Hi everyone!    I have data in a table with columns such as below:   Country (all unique) Score (calculated column) A 5 B 3 C 2   My end goal is to have rank in a column as I...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

 

You can try the following methods.

Column:

Rank = RANKX('Table',[Score])
Top2 = IF([Rank]<=2,[Country],"All Other")

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This worked! However, is there any way to make it dynamic based on whatever filters are on the page? Thanks so much! 

     

    Country (all unique)Score (calculated col)Rank (calculated col)Top2 (calculated col)Scale
    A51ABig
    B32BSmall
    C23All OtherSmall
    • v-zhangti's avatar
      v-zhangti
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, Anonymous 

       

      According to your description it should be feasible. But I need to know the output you expect, preferably with a picture to show it.

       

      Best Regards