Sort Matrix Columns in Descending Order - using a Switch Measure.

Hi all, I need help arranging the order of columns based on descending order when using "switched" measure ( Sales | Qty).

I have attached an image for your review. The current report side of the image shows what the table is doing at the moment

independently of the measure I select on the image. (it's arranging columns alphabetically)

The "Ideal report" side of the image depicts where I would like to get. The order of the columns should vary in descending oder based on the measure that is selected - Sales/Qty as noted above.

Thanks for your help!