Sort Order in Pivot Table

G

Geoffrey Zhu

Hi,

It looks like the original sort order is lost when I pivot a table. Is there
any way to preserve the original sort order?

Thanks,
Geoffrey
 
D

Debra Dalgleish

You can create a custom list, and the pivot table will sort in that order:

Type the list on the worksheet
Select the list
Choose Tools>Options
Select the Custom List tab
Click the Import button
Click OK
 
Top