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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping by month in a Pivot Table 1
Pivot table date grouping 2
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Grouping dates in pivot table 3
pivot table and grouping 4
pivot table data 2
Pivot Table Grouping 1
Duplicating Pivot Tables 2

Top