Pivot table drill down data

Z

ziak

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.
 
J

Jim Thomlinson

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...
 
Z

ziak

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table using analysis services cube as data source 0
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table drill down sort 0
Pivot table drill down 0
Pivot Chart Drill-Down 1
How to set default format of drill down report? 0
Pivot Table Counting Text Data 0

Top