Pivot table drill down data

Pivot table drill down data

Post by emlha » Thu, 22 Oct 2009 00:14:05


How can I show in descending order data that is drilled down in a pivot table
and opened as a new worksheet? There does not seem to be a sorting format
that Excel uses...seems random to me. For example, I want users to see their
highest values when they drill down in the pivot table.
 
 
 

Pivot table drill down data

Post by SmltIFRob2 » Thu, 22 Oct 2009 01:04:01

The results are in order... random order... If you wanted Ascending or
Descending then you need to sort the data after it has been exprted to the
new sheet. There is no easy way around it...
--
HTH...

Jim Thomlinson

 
 
 

Pivot table drill down data

Post by emlha » Thu, 22 Oct 2009 02:25:47

Thanks, Jim, that's what I thought. Now to tell my VP so I can get him off
my back...at least for today :-)