Welcome to Tableau Community!
Here are the steps -
1) Create a combine field for Version Number & Site Name. Put this field into worksheet.
2) Sort your above created field in descending order for Version Classification.
3) Create another calculated field using Index() function. Put this field into sheet to check the rank.
4) Now right click on index field & go to edit table calculation & compute it according to what I did -
5)Put index field into filer section (or select Index field+Ctrl (From desktop) & put in filter section) & compute the same like what we have done in step 4.
Check the attached file. Hope this may help!
SAMPLE1_PS.twbx 17.6 KB
Thanks this is working but if i want to add SiteID as well ??. I have tried index just similar to what you did and included SiteID as well but it is not working. Sorry i am asking too any questions but i am still learning tableau
Np. I am also in a learning phase. Can you please elaborate that where you want SiteID & screenshot of what output you want, so that it will be easy for me to solve your problem.