This content has been marked as final. Show 4 replies
Hello, I have a pivot table which has a dimension of "Month" in the format of "Jan 2014." I have it set to sort numerically, but the drop down selection on the pivot table is not sorting. How would I be able to get this list sorted properly?
In the screen shot, the red box shows the drop down values that are not sorted correctly. The blue box shows the rows in the pivot table that are sorted correctly. I would like to sort the drop down values the same as the row values.