This may seem a bit silly, but it worked! I'd probably really recommend simply sorting the viz by VSAT and then Survey Received to make it easier, alas...
Desired Rank 2:
Ignore Measure Names being on the filter pane; forgo to remove while testing something.
Thanks for sharing a work around.
Please note that when I applied to my data, I am not getting the desired result. Can u please check it again and share back if any.
Those highlighted in yellow is not the desired result. They should be Rank 7 and 8.
concern is - Top rank should be for those names whose vsat is 100% and move on to those with VSAT less than 100.
I'm curious of your rank calc and how your table calc is working. I just added in your extra rows and it's still work as expected:
See attached workbook.
DesiredRank_v2018.1.twbx 7.3 KB
Wow...this is great!!!
It is perfectly working now.
Thanks for sharing thoughts.
Glad it worked! Best of luck the rest of the way.
Be sure to mark one of the answers as correct to close out the thread and so others can find it.