| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
| How do I display text in the data field of a pivot table? | Excel Worksheet Functions | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Threaded Mode
