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

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

Post by RmxvcmlkYV » Sun, 25 Feb 2007 03:20:05


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

Post by U2hhbmVEZX » Sun, 25 Feb 2007 06:05:13

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