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

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!!!