To solve this I created a duplicate sheet (Sales) which is sorted by sum(sales). I then created the worlds easiest calculated field;
and dropped this onto the filters shelf for each sheet (note the second filter is set to 'exclude' to account for the two available options in your parameter)
Once this is on a dashboard inside a layout container, I removed the titles so the sheets would swap in and out based on the same parameter - i.e. you have a parameter which is handling both the data to display, and the sheet to display.
HTH 18.1 attached
sort_question.twbx 2.3 MB