Pivot Tables and Group

  • Thread starter Thread starter joey041
  • Start date Start date
J

joey041

Does anyone know why when I right click on my Pivot Table
total field, select Group and Show Detail and Group, I
get an error that Cannot Group that selection?
 
My bet is your original source data has text (or is empty) in what should be a
date cell.
 
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

Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
pivot table data 2
Grouping in a Pivot Table 1
Pivot ungrouping on refresh? 3
Are copied Pivot Tables "linked" to each other ? 2
Pivot table grand total location 1
grouping multiple tables Excel 2007 3
Pivot Table - Group by Date Excel 2007 1

Back
Top