The easiest way to sort data by a metric from a secondary data source is to have a discrete pill of the aggregated metric before dimension you are trying to sort thus taking advantage of the default sort in Tableau.
Check the attached for a sample solution.
Sample Solution.twbx 38.7 KB
It worked for me! Thanks a ton for your help☺