View Single Post
  #3   Report Post  
Gary Brown
 
Posts: n/a
Default

Right click on the date field within the Pivot Table.
Select 'Field Settings'
Select 'Advanced'
Under 'AutoSort Options', select 'Ascending'.
HTH,
--
Gary Brown



"D Beals" wrote:

My pivot table data is appearing with the dates out of order. How do I get
the dates to appear in order?

1/1/05 1st date
1/5/05 2nd date
1/2/05 third date