1 Reply Latest reply: Sep 26, 2011 5:45 PM by Roberto Montanari RSS

    PivotTable Sorting Problem (not Date-Related)

    Steve Barron

      I have a table with Account names:


      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?