How to group date in pivot table

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

Guest

has followed Excel's instructions, but still could not group date (into
month, year, etc) from a column of date in a table. Message 'Cannot group
that selection' even though the whole column (cells) had been reformated in
date format. Please help.
 
If there are text entries, or blank cells in the date column, you won't
be able to group the field. Perhaps you included some blank cells in the
date column. If that's the problem, you could add a "dummy" date to
records with no date.
 
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
How do I convert dates to months in Pivot Tables? 1
date filter in a pivot table 1
Grouping dates in pivot table 3
Pivot Table Change to US Date Format - Why? 2
Pivot table date grouping 2
Can't Group Dates in Pivot Table 13
Grouping in a Pivot Table 1

Back
Top