Hi Hari

ToolsOptionsCustom Lists delete the custom list which exists starting
Nov,Dec, ..... Oct
Create a New one with Jan,Feb,Mar .... Dec
Refresh your Pivot table.

--
Regards

Roger Govier


"Hari" wrote in message
oups.com...
Hi,

In my base data I have fields for Year, Month, Date, Field1 and a few
measures associated with them. New data for succeeding dates/months
are
appended below the earlier dates/months.

One of my former colleagues had made a Pivot table out of the above
data and each time when it was refreshed it used to have the
months/year displayed in increasing order of time without involvement
of any macro etc. (I couldnt figure out as to how Pivot could manage
that as with some of my other data, the time periods always used to be
displayed in alphabetical naming order rather than increasing months).

Presently with data entered for November (and partial data for
December) in the above base data table and refreshing pivot, November
and December make to the top of the summary for that year. Iam
attaching the sample diplay below. Also there is a Pivot chart linked
to this table and thats also getting muddied up.

I want to understand as to how I can achieve Pivot to display data in
natural order of time (without using an macros or mutliple
manipulations) Or at the vey least Pivot should be able to Present
summaries in the order in which values for the row fields appear in
the
base table.

Regards,
HP
India

Fiscal Year Month Field 1
2005 July 39
August 319
September 383
October 521
2005 Total 1,262
2006 November 11,920
December 3,980
January 5,635
February 6,186
March 7,686
April 7,682
May 6,857
June 6,230
July 6,505
August 3,483
September 4,930
October 8,289
2006 Total 79,383
Grand Total 80,645