Sorting Sub-Columns in a Matrix Table

Hello,

I am currently unable to sort my matrix visualization by sub columns. I want myself and end users to be able to click on any fiscal month within a matrix (such as August 2020) and have all of the data points (count of lead) sort (either asc or desc) by count. Currnetly, the table is sorted by default by descending by count of fiscal year (which is the grand total)

Please note that for the matrix depicted, there are two column headers: A fiscal year header, followed by a fiscal month header. Rows are grouped as well - by campaign.

Again, the desired functionality is that I should be able to click on the header of ANY column, whether it be an individual month, a year subtotal, or the grand total of all years, and have it sort (asc or desc) by count. I have searched for solutions, but all solutions seem to be centered around creating a calculated measure. I don't think this will work, as at the end of the day the calculated measure still has to be sorted by year/month/grand total.