Excel 2013. This is my PIVOT table where the item labels are in tabular form. What I am trying to do is sorting as follows :
- column 1 sort order should be Red, Amber, Green
- Column 2 sort order should be A-Z
- Column 3 sort order should be PCC3,2,1,0
How can I accomplish this? I tried more sort options. No use. Can this be done using excel VBA?
Aucun commentaire:
Enregistrer un commentaire