If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|