Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot date grouping
I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I save the worksheet as a csv file and the back into an excel file the date grouping works fine. This however does not solve my problem. hel please |
#2
|
|||
|
|||
When you get the data from the query, the dates may be imported as text,
which would prevent them from being grouped. There are instructions here for converting the text dates to real dates: http://www.contextures.com/xlDataEntry03.html sue wrote: I have a spreadsheet that has been obtained from a external database query. I am now trying to group the dates into months and years, however no luck. If I save the worksheet as a csv file and the back into an excel file the date grouping works fine. This however does not solve my problem. hel please -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Suggestions will vary depending on version. Please provide more info. |:)
"sue" wrote: I have a spreadsheet that has been obtained from a external database query. I am now trying to group the dates into months and years, however no luck. If I save the worksheet as a csv file and the back into an excel file the date grouping works fine. This however does not solve my problem. hel please |
#4
|
|||
|
|||
Hi
I am working with office 2003 professional- The date is formatted as *14/03/2001 however the pivot table does not seem to reconize this as a date - "CyberTaz" wrote: Suggestions will vary depending on version. Please provide more info. |:) "sue" wrote: I have a spreadsheet that has been obtained from a external database query. I am now trying to group the dates into months and years, however no luck. If I save the worksheet as a csv file and the back into an excel file the date grouping works fine. This however does not solve my problem. hel please |
#5
|
|||
|
|||
Hi thankyou,
the date is formatted as *14/03/2001, it appears to be reconized as a date for everything but the pivot table. "Debra Dalgleish" wrote: When you get the data from the query, the dates may be imported as text, which would prevent them from being grouped. There are instructions here for converting the text dates to real dates: http://www.contextures.com/xlDataEntry03.html sue wrote: I have a spreadsheet that has been obtained from a external database query. I am now trying to group the dates into months and years, however no luck. If I save the worksheet as a csv file and the back into an excel file the date grouping works fine. This however does not solve my problem. hel please -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables by date range | Excel Discussion (Misc queries) | |||
Pivot table will not group a date field | Excel Discussion (Misc queries) | |||
Pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot table-date grouping | Excel Discussion (Misc queries) | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) |