Pivot Table 'page' field

J

Jeff

I have a pivot table in which my Month field is placed in
the 'page' location of the table. This allows me to click
on Month to access a drop down list and choose which
month's data I want to view. Is there a way to sort or
arrange the way the items are displayed in the drop down
list? How is the order of this list determined?
Sometimes these lists are automatically placed in a
logical order (alphabetic or numeric), but other times it
is diplayed differently. Currently my month field is
displayed in this order:

1
10
11
12
2
3
4...

Any ideas?

Jeff
 
D

Debra Dalgleish

The month numbers in the table are being treated as text, and sorted
alphabetically. So, all the numbers that start with a 1 appear first in
the list, then all the numbers that start with a 2.

Depending on how the month numbers are entered in the source table, you
may be able to use one of the methods show here to convert them to real
numbers:

http://www.contextures.com/xlDataEntry03.html

Then, refresh the pivot table, and the numbers should sort correctly.
 
Top