How do I change a pivot table report to sort when I drill down

[Guest]

I have a pivot table set up and when I click on a cell to drill down, it
pulls up all the data but the sort makes no sense! Does anyone know what the
sort criteria is and how to change it??

 

[Guest]

I don't have time to test this right now but I suspect the order is the order
of the data in the data source. So sort your data souce, not the pivot table
and then do the drill down.