Sort Pivot Table by Name
Hello, I have a Pivot Table and I want to sort the Column Labels by name.
As per below: I want the Column Labels to be: W1,W2... W10 and I can't sort it.
Count of Request Type Column Labels
Row Labels W1 W10 W3 W4 W5 W6
Sample1 1 2 3 4 5 6
Sample2 10 10 10 10 10 10
Sample3 1 5 10 5 6 7
Sample4 15 10 10 10 10 10
Heres the attachment: pivot.jpg
Thanks in advance.
Last edited by siobeh; 09-02-2013 at 05:46 AM.
I've got it. Resolved.
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks