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
Bookmarks