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:
One expression, sorting broken:
Has anyone else encountered similar behaviour?