Column Order when expanding pivot is reversed
I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
e.g.
If I have something with a pivot
Sum(Amount) for month_no in ([1],[2],[3]....)
When the pivot result is expanded, it becomes [12],[11],[10]....
Would be nice if the expansion would match the order that the columns was entered in.
1
vote
![](https://secure.gravatar.com/avatar/99d2489c118038729e4b5d8da30758c1?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)