Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table dates are out of order how do I correct them
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 |
#2
|
|||
|
|||
I did what you said and the dates still appear out of order. I created a
pivot table for daily quotes. When I update the pivot table all of the dates are ascending except for some reason 5/14/2005 keeps coming up as the last date in the table. "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 |
#3
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table, vba or ??? | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Start & End Dates in pivot table | Excel Discussion (Misc queries) | |||
pivot table in data source order | Excel Discussion (Misc queries) |