MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot table -

Posted by lEE on October 15, 2001 9:42 AM

my data sheet has the column sorted in a specific order, when I transfer it to a pivot table it sorts the columns in alpha order. is there any way to have ti sort the way the data is inputed.

Posted by Mark W. on October 15, 2001 10:01 AM

Create a custom sort order (see the Excel Help
topic for "Create a custom fill series or
sorting order") and your PivotTable will
use it! For example, suppose Field1 contains
{"dog";"cat";"bird";"mouse"}. After you've
defined this as a custom sort order, a PivotTable
containing Field1 with an Ascending AutoSort will
be sorted in {"dog";"cat";"bird";"mouse"} order.