Forum Discussion
Office 365 excel pivot sorting bug
Hi I'm using Excel office 365. Seems sorting Error in pivot table, for alphabet (a,b,c,d,e,f) sorting showing as (a,d,b,c,e,f) Row Labels A D B C E F G H Grand Tot...
In general PivotTable sorts in alphabetical order
If to add some non-printable character (usually happens if data copy/pasted from web) when we may reproduce your case
That could be custom sorting list in settings.
If you have not "A" and "D" but texts with special characters sorting order also could be not necessary alphabetical.
Whatever...
It's better to check sample file if possible.