Sorting of Column Fields in a Pivot Table

smalik

Board Regular
Joined
Oct 26, 2006
Messages
110
Office Version
  1. 365
Platform
  1. Windows
Is there a way to sort the fields in a Pivot Table manually?

Currently, the following Column titles are showing up in the the Pivot Table
1605020869500.png


Excel is sorting the fields based on the numbers in the field name. However, I like to get the Column titles in the following order:
1605020962458.png

This makes more sense to me than the numerical order Excel is sorting. In addition, there is another field that needs to come either at the beginning or at the end "Due in the Future"

I had a work around but I am told that this work around is not acceptable.
1605021079350.png


I looked into the manual sort option. It says to use the drag and drop option but I don't get the option to choose my fields. I even checked "YouTube" videos but none of them show how to adjust the fields. They all show how to sort the data in Pivot Table.

I do not know VBA so is there a way this can be done without using a VBA macro? or VBA is the only option I have?

Any help is greatly appreciated.

Thanks in advance.
 
Last edited:

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

smalik

Board Regular
Joined
Oct 26, 2006
Messages
110
Office Version
  1. 365
Platform
  1. Windows
I found a work around so thanks to everyone who looked into this.
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,303
Glad to hear you found a workaround for your question.

Do you mind posting about your solution? Then it is perfectly fine to mark your post as the solution to help future readers.

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,517
Messages
5,602,124
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top