Note that, in the database, 1199 sorts before 4D, then we start the alphabet.
In the PivotTable, however:
...4D appears before 1199. (Yes, I checked that there is no leading space or anything in the name 4D. )
Market, Product and Account are all set to sort by Text. If I change Account to sort by the field name in the Expression section, it sorts correctly.
Is a Text sort not trustable? I know that just about anything in QV is stored both as Test and Numeric - and it looks like it's sorting the 4 before the 11. Should I always be entering Expressions? Maybe wrapping the field name with some sort of Text() function?