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

    PivotTable Sorting Problem (not Date-Related)

      I have a table with Account names:

      SQLDEV.bmp

      Note that, in the database, 1199 sorts before 4D, then we start the alphabet.

       

      In the PivotTable, however:

      pivot.bmp

      ...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?