Thread
:
pivot table dates are out of order how do I correct them
View Single Post
#
3
Gary Brown
Posts: n/a
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
Reply With Quote