I believe I may have solved the issue using this link: https://www.theinformationlab.co.uk/2014/11/03/understanding-sorting-tableau/
In the comments section, this did the trick
On monday, I'll see if my current workaround will play nice with filters. Thanks!
2 of 2 people found this helpful
I knew that way as well but I sent you the preferred one
Combined fields will give you
1) A little different format (that again can be sorted out but extra work )
2) Combined field can't be used for Calculations
For ex if you like to have only top 3 under each country , you can do that with Rank filter but not with combined fields.
So folks generally make use of Rank instead
I have made one video also on this -->Nested and Dynamic SORTING with Top & Bottom N cases Tableau (Hands-on) - YouTube
Please mark this thread as CORRECT / HELPFUL if it really helped you so that it can help others as well.
Just did, thanks again for the help Ritesh! The Rank function is definitely the way to go