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 sort 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table drill down data 2
Print order of TriFold - Publisher 365 0
Dealing with a Pivot Table (when I don't want to) 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Pivot table drill down 0

Top