The sample dataset which the tableau file is using is on a server. Hence, unable to connect to the data. Can you use excel file and share the packaged file.
could not open the book - see the example below from superstore data
create the rank using the top n filter option
next create the viz
then open (right click) the dimension (here cust name) and select sort by field
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.