I have tried one solution to your problem,
Desired Result :
What I did was
1. Change the RankOnAbsolute calculation from Rank to Rank_Dense
2. Change Absolute Value Calculation
3.Edit Table Calculation of Rank on Absolute and select Specific Dimensions
then it will show the desired result. I am also attaching my workbook here.
I hope it helps please mark it as the helpful and correct answer.
RankTest_Tableau.twbx 15.2 KB
@ Amar : Thanks for taking time to respond with the screenshots etc. but my question was little different.
@ Kalpit : That was spot on ... so I guess from technical perspective, for table calculation, I was not correctly choosing correct dimensions for "Compute Using" & I was also not using "level of computation i.e. deepest" & "restrating every" part. Thanks for your assistance, easy to follow & prompt response ... awesome mate ..more power to you...
Thank you, great to hear from you.