Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping in a Pivot Table
I have created a Pivot Table off of a spreadsheet containing sales related
information. I am trying to group the "Due Date" field into months and I keep receiving an error that I cannot group the selection. I have used this feature before with success and I am stumped as to why it is not working this time. Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping in a Pivot Table
Most often it has to do with having blank cells or text mixed in with your
dates. Check out this link. Once you have changed all of your items into dates you may have to refresh your pivot table twice before you will be able to group by dates. http://www.contextures.com/xlPivot07.html -- HTH... Jim Thomlinson "LMorman" wrote: I have created a Pivot Table off of a spreadsheet containing sales related information. I am trying to group the "Due Date" field into months and I keep receiving an error that I cannot group the selection. I have used this feature before with success and I am stumped as to why it is not working this time. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot table grouping | Excel Discussion (Misc queries) |