I have a pivot table created from a sheet of rows with employee and date columns (among others) sorted by employee and date. When you double click on one of the employees on the pivot, the resulting sheet shows only that employee's rows from the main sheet all right, but they are sorted in reverse order by the date, not in forward order by the date as on the source sheet. How can I get the drill-down resulting rows to appear as they appear in the source sheet, sorted in forward order by date?
Bookmarks