Jul 11 2020 11:18 AM
Hello all,
I have a pivot table in format table with 10 columns of data. I would like to order the 7th column from A to Z, or if possible with a custom order. If I order it from A to Z nothing appens. If I do the same to the first and the second column it works instead.
Do you know any solutions to order from A to Z a column which is not in the first positions (e.g. first or second), and if possible do you know how to order it in a custom way ?
Thanks a lot,
Alessandro
Jul 11 2020 11:46 AM
Sorting on columns from the rows area works only within the scope of the previous column.
As you already found out you have to move the column to the first position to get the "full experience".
Jul 11 2020 11:49 AM