Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort order of pivot table drill down
Hello,
One of our users puzzled me again. :) Excel 2003, query to a DB2 database. User made a pivot table which uses this query as its data source. When opening the drill down of a certain cell (left double click), a new sheet is created. The new sheet has no formatting and no (apparent) sort order. His question: how to automagically set the sort order for the drilldown? According to some sources, this is determined by the sort order of the source data. So that would be fixed with an "ORDER BY" in the query. But other sources contradict this. Any ideas? -- Amedee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table aging report sort order | Excel Worksheet Functions | |||
Pivot table sort order | Excel Worksheet Functions | |||
How do I change a pivot table report to sort when I drill down | Excel Worksheet Functions | |||
Sort order not being matched in pivot table | Excel Discussion (Misc queries) | |||
Pivot table sort order | Excel Discussion (Misc queries) |