Pivot Table - Group by Date Excel 2007

E

evoxfan

In my pivot table I tried to right click the "Date" column in order to group
by month.
A message popped up "Cannot Group that Selection".
Is there another way to group by month?
Should I create another column for month in my data source?

These are my headers for data source on another worksheet in the same
workbook.
PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE

Thanks in advance for any help.
 
E

evoxfan

I found the error.
Some of the dates were blanks or the values in the amount column were blanks.
After correcting the data, the pivot table worked fine.
 

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

Excel 2007 Pivot Table Question 2
pivot table data 2
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Group by month in a Pivot table 2
Pivot ungrouping on refresh? 3
Pivot Table Variance 2
Grouping in Pivot Table 3
Group by Month in Pivot-table 4

Top