Powerpivot, re-ordering calculated fields

[cr731]

I've noticed that calculated fields appear in the pivot table field list in the order they are created. Is there any way to manually change the order? Such as to group like calculated fields together (which would be different from both alphabetical and order of creation)?

 

[Matt Allington]

Yes, there is a "sort by column" button in the Power Pivot window. Just import a second column (integer is best) that maps to your original data and is in the correct sort order. Then click the text column, click 'sort by column' and then select the numeric column.