Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group Pivot data by week
I am trying to automaticallly group a pivot table by week. When I go into
group... from the pivot table field, I get a dialog box that says I can not group. I can manually select these dates and group them, but new dates are added to my data source daily, and I would like this report to automatically group them. What am I doing wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group Pivot data by week
That error can occur if there are blank cells or cells with text in the
date column. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems cbrah wrote: I am trying to automaticallly group a pivot table by week. When I go into group... from the pivot table field, I get a dialog box that says I can not group. I can manually select these dates and group them, but new dates are added to my data source daily, and I would like this report to automatically group them. What am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group Pivot data by week
Thanks Debra - I'm sure thats it.
"Debra Dalgleish" wrote: That error can occur if there are blank cells or cells with text in the date column. There are some suggestions here for fixing the problem: http://www.contextures.com/xlPivot07.html#Problems cbrah wrote: I am trying to automaticallly group a pivot table by week. When I go into group... from the pivot table field, I get a dialog box that says I can not group. I can manually select these dates and group them, but new dates are added to my data source daily, and I would like this report to automatically group them. What am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Group by Week? | New Users to Excel | |||
How do you group data in a Pivot Table? | New Users to Excel | |||
group sales by week and week number | Excel Discussion (Misc queries) | |||
Why does the pivot table not allow me to group data? | Excel Discussion (Misc queries) | |||
Pivot table - group dates per week or month | Excel Discussion (Misc queries) |