Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drill down data
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drill down data
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 "ziak" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drill down data
Thanks, Jim, that's what I thought. Now to tell my VP so I can get him off
my back...at least for today :-) "Jim Thomlinson" wrote: 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 "ziak" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Drill Down | Excel Discussion (Misc queries) | |||
Pivot table drill down | Excel Discussion (Misc queries) | |||
Pivot Table drill down | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Top 10 within a drill-down in a pivot table? | Excel Discussion (Misc queries) |