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!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping a data field in a pivot table
You can group by Day and Month (by week is a bit trickier as it will only
allow you to group by every 7 days based on the date of the earliest date in the field). If you group by a set number of days then you can not group by month, year, etc... That being said you need to make sure that the date field is dates and not text otherwise you will not be able to group. When you select group you should get a dialog allowing you to group by Day, Month, Quarter, Year (along with time). If you do not get that dialog then post back with what you do get... -- HTH... Jim Thomlinson "mercedes" wrote: 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!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping a data field in a pivot table
I still don't get the dialog. i have formatted the cells to indicate they
are dates. "Jim Thomlinson" wrote: You can group by Day and Month (by week is a bit trickier as it will only allow you to group by every 7 days based on the date of the earliest date in the field). If you group by a set number of days then you can not group by month, year, etc... That being said you need to make sure that the date field is dates and not text otherwise you will not be able to group. When you select group you should get a dialog allowing you to group by Day, Month, Quarter, Year (along with time). If you do not get that dialog then post back with what you do get... -- HTH... Jim Thomlinson "mercedes" wrote: 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!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping a data field in a pivot table
Mercedes
If you don't get the dialog, do you get any error, like 'Cannot group that selection'? If the source data is in Excel try copying a 1 and then highlight the 'dates' and editpaste specialValues and multiply. Now format these as dates and make sure there are no spaces or other data other than dates and it should work then -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "mercedes" wrote in message ... I still don't get the dialog. i have formatted the cells to indicate they are dates. "Jim Thomlinson" wrote: You can group by Day and Month (by week is a bit trickier as it will only allow you to group by every 7 days based on the date of the earliest date in the field). If you group by a set number of days then you can not group by month, year, etc... That being said you need to make sure that the date field is dates and not text otherwise you will not be able to group. When you select group you should get a dialog allowing you to group by Day, Month, Quarter, Year (along with time). If you do not get that dialog then post back with what you do get... -- HTH... Jim Thomlinson "mercedes" wrote: 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!!! |
Reply |
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) |