0 Replies Latest reply: Jul 22, 2011 8:11 AM by Nick Swift RSS

    How to sort by two expressions in Pivot?

      Hi,

       

      I have a pivot chart with a dozen or so columns in.  I want to sort the pivot by two of the columns, both of which are expressions.  No problem with the first one, I simply add the expression to the initial dimension column and it works.  But how do I then sort by the second column (expression) for those items with identical values on the first column (expression)?

       

      I've tried adding it to the second dimension field, which seems to be ignored completely.  I've tried working on the expression to sort by expression 2 if expression 1 matches, but no luck.

       

      Any ideas out there?  I'm using QV10 SR1.

       

      Thanks

      Nick