Can't group by dates in Excel 2003 pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do not get a Group By dialog box when I select Group. It adds a group name,
but puts everything in one big group.
 
If there are text entries, or blank cells in the date column, you won't
be able to group the field. If that's the problem, perhaps you could
delete any text, and add a "dummy" date to records with no date.
 
Hi Debra,

I have the same problem - can't group dates (into by month, quarter, or
year). I have reformatd the date column (cells) in date format. Any other
suggestion pls

Minh Le
(e-mail address removed)
 
Are there any blank cells in the data column of the source data?
Did you include blank rows at the end of the pivot table?
 
Hi Deb,

Source data is from Excel sheet, there is no blank cells in that column of
the data table (note the data table did not fill the whole sheet); and I did
not select blank row in pivot table.

Thanks for your help

Minh Le
 
You must log in or register to reply here.

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

Pivot Table - Group by Date Excel 2007 1
Grouping Years in a Pivot table 2
grouping multiple tables Excel 2007 3
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Pivot ungrouping on refresh? 3
Change quarters in Pivot table when grouping 1
Duplicating Pivot Tables 2
Pivot Tables with different groupings based on same data table 6

Back
Top