Pivot Table Help required

cd23

New Member
Joined
Oct 28, 2006
Messages
1
I have the whole data monthwise for 3 years. On analysing it through pivottable. when i insert month on rows, it arranges the data as follows
apr -03 aug -03 dec -03 (that is alphabetically)
instead of
apr -03 may -03 jun -03
can you help me in rectifying this problem
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Cloverken

Active Member
Joined
Feb 18, 2002
Messages
271
More than likely your dates are formatted as text. Therefore Excel does not recognize the date sequence you would like and alphabetizes the text.

Check the formatting of your dates and change them to a date format by selecting them and going to Excel menu selecting "Format" then "Cells..." then "Number" tab then select "Date" and pick format you would like.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,365
Members
410,679
Latest member
rolandbianco
Top