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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Florida_Raider - 23 Feb 2007 18:20 GMT

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

Reply to this Message

ShaneDevenshire - 23 Feb 2007 21:05 GMT

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.

Signature

Cheers,
Shane Devenshire

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

Reply to this Message