Sorting pivot table by grand total based on one of three multiple row values per cust

I’m sorry. I’m trying to do this on my phone. I’ll delete previous posts.

I have exhausted my search for an answer. I find it hard to believe it’s this difficult.

I have a pivot table, the first three rows are Sales Man, Customer, Last Date of Service then a row per customer over the last three years. There are 12 columns for each month.

So for each Sales Person/customer there will be up to three rows. I only want to sort based on row column Year = 2018.

My challenge is to first sort by Sales Person in descending order based on the grand total in descending order based on the current year. I’ve not been able to find a solution!!

I’ve posted before and haven’t gotten a reply. If someone could please help me to sort this out I would genuinely appreciate it. Getting a little hot round the collar at work.. know what I mean??!!

Thank you for any help you can provide!
Windows 10
Office 365
(Some VBA coding experience, if that’s needed)

I should also mention that there are 12 columns for each month. I realize there are work arounds when there are fewer columns but that is not the case in this scenario.

Thank you.

Can you post a sample (workbook, not picture) of what you’ve got and a (manual) mock-up of what you want?

If the filter in cell D7 (Year_) is set to display only 2018, then the names of the customers will appear in the order stated in post #5.
To display the values from the past three years in a pivot table, it may require adding helper columns to the source data.
Let us know if you have any questions.