Pivot Table column sorting

[rciolkosz]

In my pivot table I have 10 columns 1-10. I check advanced > manual
ascending but when the pivot displays, the 5 follows the 10 at the end of the
columns. I am not sure how to do the custom order feature.

 

[Debra Dalgleish]

In the pivot table, click on the heading cell for 5
Point to the border of the selected cell
Drag it to the left, until the pointer is where you want the column located
Release the mouse button, and the 5 column will be in the correct position.

 

[rciolkosz]

Thanks a bunch, once I figured out to right click and drag then it worked.