sort order of pivot table drill down

A

Amedee Van Gasse

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?
 

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

Pivot table drill down data 2
Pivot table drill down sort 0
Pivot table - drill down - format 0
Pivot Table Drill down - what does it sort on 1
Pivot Chart Drill-Down 1
Pivot Table Sort Order 1
Pivot Table: Resulting Column Widths on Drill Down 0
Pivot Table drill down 1

Top