pivot - manual order at a specific row label (no A-Z / Z-A sorting)!!

viola38

New member
Joined
Feb 2, 2016
Messages
2
Reaction score
0
Points
0
Hello, how can I manually sort one row label in a pivot table?? The Pivot sorts it automatically A-Z or Z-A. but the order of this parameter in my pivot is fundamental. How can It be performed??
 
You can manually order items in the pivot by dragging. Click on the label, then use the pointer to grab the edge and drag up or down as needed, will see a green outline showing where it will be inserted.

Another approach - if the items in the pivot are static (ie will not change, or be added to or removed), then you can use a Custom List (Google how to use those) and then sort A-Z as per normal.
 
Back
Top