LinkBack URL
About LinkBacks
My Pivot Table has a different row for each month of a particular year. These are individual items not groups. The row label is the month number, as in 1,2,3 ... 11, 12. But the rows sort like this:
1
10
11
12
2
3
etc.
How can I fix this?
Art
My Pivot Table has a different row for each month of a particular year. These are individual items not groups. The row label is the month number, as in 1,2,3 ... 11, 12. But the rows sort like this:
1
10
11
12
2
3
etc.
How can I fix this?
Art
The values in your Pivot are Text rather than Number - convert from Text to number at Source, refresh the Pivot and they should sort accordingly else if you have just the 12 months sort them manually (drag them into order).
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks