Thank you for your help, but it is not working for me .
Perhaps I am not understanding.
I don't thin I want to sort by subtotal. I would like to keep all values desperate and sort as if they were just regular rows, but keep the pivot table properties.
Because I have multiple "MC"...
What error are you getting?
Are you naming the entire range of the data? or just the headers? If you are naming the entire range it should work.
Can you post an example workbook?
Hi all,
I am new to the forum and signed up for the VBA Class recently. I love the atmosphere of Chandoo and have learned a ton.
I have a question regarding a pivot table sort.
The file can be found here...