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

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??

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

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.
--
Cheers,
Shane Devenshire


"Florida_Raider" wrote:

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??