Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - Grouping
Hi Folks:
I'm using a small table (~700 rows and 15 columns) as a Pivot Table source where I'm trying to group sales results by customer by month/year. Typically I've never seen this, but in this case, Pivot Table is reporting "Cannot Group That Selection". I'm guessing this is a date formatting issues, but I've tried everything. Any help appreciated . . . . Thanks Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - Grouping
If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table. http://www.contextures.com/xlPivot07.html Or, if the dates are being treated as text, you won't be able to group them. If so, you can change the dates back to numbers, as described he http://www.contextures.com/xlDataEntry03.html slow386 wrote: I'm using a small table (~700 rows and 15 columns) as a Pivot Table source where I'm trying to group sales results by customer by month/year. Typically I've never seen this, but in this case, Pivot Table is reporting "Cannot Group That Selection". I'm guessing this is a date formatting issues, but I've tried everything. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - Grouping
Debra:
Thanks. I checked the entire column - no blanks - also checked formatting - no help. Any other thoughts?? Hope all is well Steve "Debra Dalgleish" wrote in message ... If there are any blank cells in the date column, you won't be able to group the dates in the pivot table. http://www.contextures.com/xlPivot07.html Or, if the dates are being treated as text, you won't be able to group them. If so, you can change the dates back to numbers, as described he http://www.contextures.com/xlDataEntry03.html slow386 wrote: I'm using a small table (~700 rows and 15 columns) as a Pivot Table source where I'm trying to group sales results by customer by month/year. Typically I've never seen this, but in this case, Pivot Table is reporting "Cannot Group That Selection". I'm guessing this is a date formatting issues, but I've tried everything. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - Grouping
Fixed - I made a bad selection . . .
Sorry "slow386" wrote in message ... Debra: Thanks. I checked the entire column - no blanks - also checked formatting - no help. Any other thoughts?? Hope all is well Steve "Debra Dalgleish" wrote in message ... If there are any blank cells in the date column, you won't be able to group the dates in the pivot table. http://www.contextures.com/xlPivot07.html Or, if the dates are being treated as text, you won't be able to group them. If so, you can change the dates back to numbers, as described he http://www.contextures.com/xlDataEntry03.html slow386 wrote: I'm using a small table (~700 rows and 15 columns) as a Pivot Table source where I'm trying to group sales results by customer by month/year. Typically I've never seen this, but in this case, Pivot Table is reporting "Cannot Group That Selection". I'm guessing this is a date formatting issues, but I've tried everything. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot Table or Grouping Help | Excel Discussion (Misc queries) | |||
pivot table grouping | Excel Discussion (Misc queries) | |||
Grouping in Pivot Table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) |