Forum Discussion
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...
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 |
| A | 5 | 1 | A | Big |
| B | 3 | 2 | B | Small |
| C | 2 | 3 | All Other | Small |
v-zhangti
Community Support
Community SupportHi, 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