Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dates in pivot not coming up with years
I have a date field in my pivot table, for which source data not only has the
year, but also the time. When I get it into the pivot table, however, there is no way I can figure out to get it to show me (both in the dropdown for selection of range or in display of the labels) the date with the year. As such, because the data spans several years, it's hard to guess which dates to include and eliminate in order to capture any particular month of a particular year. Any clues? I know I have no blanks in there, which sometimes throws date fields off. I know my source is formatted to date format. I don't have any other ideas of what to try. Thanks for any help. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Dates in a Pivot table for years that are not calendar ye | Excel Worksheet Functions | |||
Graphics coming from a Pivot Table. PLEASE HELP!! | Excel Discussion (Misc queries) | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions |