We are calculating Rank of each city across various level.
Level 3 EG for City ABC is Rank 2 as the Avg Score is 67.70
Level 3 EG for City PQR is Rank 1 as the Avg Score is 68.33
I hope that clarifies.
I added a table calculation for rank, but get three values different to your screenshot.
For example, my rank is,
Level 3 EG Level 4 Q6 for City ABC is ranked with 1 as the Score is 83.07
Level 3 EG Level 4 Q6 for City PQR is ranked with 2 as the Score is 65.00
which is opposite to the screenshot.
With the introduce of table calculation rank, it becomes impossible to use "use as filter" function in the dashboard.
Instead I created a parameter.
Please check out the attached workbook.
Example (1).twbx 53.0 KB
I guess the problem is solved using your solution, let me try it on the production data.
Appreciate your help and assistance.
Your solution worked.
Thanks a lot