VBA code to sort pivot table's Grand Total column based on cell.row.value

I hope someone can help me with this. I've searched and searched but can't find any help on this topic. I have a Sales pivot table with the following Rows:

Sales_Rep\Customer\Last_Date\Year

Capture.PNG

This data reports back to 2016 for most customers (but not all). I want to show Sales_Reps in descending order based on their 2018 Grand Totals.
Within each Sales_Rep, I want to show Customers in descending order based on their 2018 Grand Total.

I have tried using the 'more sort options' Descending (Z to A) by 'Sum of Revenue' and 'more options' with AutoSort marked and Sort By Values in selected column $Q$10 (which is the column where row where year = 2018).

This does not produce the desired results. I'm guessing that a VBA code would be the best way to produce the results I'm looking for but I don't know how. Can anyone please help me out here?

Thank you.
Marlene

Excel version 2013

Can anyone please help? I'm trying to sort in descending order on year = 2018