Pivot Table column sorting
 

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.

Pivot Table column sorting
 

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Pivot Table column sorting
 

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

"Debra Dalgleish" wrote:

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html