View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Grouping a data field in a pivot table

Mercedes

What do you mean by 'only giving you the option of days'?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mercedes" wrote in message
...
I am trying to group some dates, I would like to do day, week and month. I
right-clicked and went to Group and Show Details, and then to group but it
only groups them bu day. It does not even give me the option of grouping
by
anything else. I went to the help and it says that when it is a date
field
it should give you the option of how to group it by. Why is it not doing
it
for me?? Help!!!