Grouping in a Pivot Table

L

LMorman

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!
 
J

Jim Thomlinson

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
 
Top