"Group and show detail" is an option when I click on that field in xl2003.

I'm not sure if they changed this caption from earlier versions (but they have
changed a bunch of captions through various versions).

Try Group and see where that leads.

ps. Post the version of excel, then someone with that same version can jump in
if you have trouble.

BorisS wrote:

Dave, the second idea is certainly something that would work (is my guess),
but I like to avoid adding columns, especially given I'm already pushing 8k
records with lots of data (the file is getting monstrous on its own without
additional columns, and I'd have to do this several times to fix other dates
if I were to do it that way).

On your first point, I am not quite clear...I am assuming the litmus test
for "real dates" is whether the grouping dialogue comes up (because it
doesn't even do that if you have a blank, much less something that is not a
date). I do get that dialogue. As for "group and show detail" I am not sure
where that is. I have group and I have show detail, but given that the date
is the only field I have in the row area, "show detail" would require me to
pick a "detail" field to show, which I don't really need to do. I guess I am
miffed by why Excel chooses - with all the date data points I have in the
source data and formatting (day, month, year, time) - to only show me the
options of day and month on the pivot (without my having chosen for it to do
that in the first place). Am I making sense as to why I am not understanding
your first idea?
--
Boris

"Dave Peterson" wrote:

If your dates are real dates, you could rightclick on the Date field (In the
pivottable) and choose "Group and show detail".

Then you could group my month (or month and year).

Another option might be to use another column of formulas:

=text(a2,"yyyy-mm")

And use that in the pivottable.

BorisS wrote:

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

--

Dave Peterson


--

Dave Peterson