Forum Discussion
insandur
3 years agoHelper II
Top N selection on Ranks
I have a table with below columns and created a dyanmic measure "Rank" on savings and now i want to have option as TOP 3,5,7,10 ideas as filter options based on Rank and it should be dyanimc when i use filters on "Function" column.
| Ideas | Savings | Function | Rank |
| A9 | 95070 | Travel | 1 |
| A4 | 81900 | IT | 2 |
| B7 | 81174 | Commercial | 3 |
| A1 | 80422 | Education | 4 |
| A7 | 52209 | Travel | 5 |
| B6 | 48892 | Education | 6 |
| A10 | 44861 | Commercial | 7 |
| B5 | 36907 | Education | 8 |
| A5 | 35886 | Travel | 9 |
| A8 | 32030 | IT | 10 |
| A2 | 25838 | Commercial | 11 |
| A3 | 9055 | Travel | 12 |
hope this can help
1 Reply
- wdx223_DanielCommunity Champion