1 Reply Latest reply: Oct 31, 2014 6:27 AM by Nikolaos Kavroulakis RSS

    Pivot Table sort bug when using Conditional Expressions

    Michael Fenton

      I have a pivot table with four expressions.  The expressions are conditional, allowing the user to show/hide any combination.

       

      The pivot table has column grouping by month (in the form "Jul-2013").  The column order is sorted correctly if the user selects two, three or all four expressions.  However, if only one expression is shown, the column sorting changes and I cannot get it to display in the correct order.  Please see the following screen shots.

       

      Two expressions, sorting correct:

      Pivot Table - 2 expressions.jpg

       

      One expression, sorting broken:

      Pivot Table - 1 expression.jpg

       

      Has anyone else encountered similar behaviour?