Pivot Table Drill down - what does it sort on

Pivot Table Drill down - what does it sort on

Post by Q2hlcmllV2 » Fri, 02 Jul 2004 04:10:02


I have a worksheet which I created a pivot table on. One of the fields in the pivot table is w/e date. I have selected ascending for sort order on W/E date. But when I double click on the data field in my pivot table to drill down, it still does not sort appropriately. Any ideas?
 
 
 

Pivot Table Drill down - what does it sort on

Post by Debra Dalg » Fri, 02 Jul 2004 10:12:44

How do the dates sort?
Do they sort as expected in the pivot table?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.yqcomputer.com/