PivotTable question - date format

  • Thread starter Thread starter -= cj =-
  • Start date Start date
C

-= cj =-

Thanks Debra,

For some reason when on that Date field button in the
Pivot table & choose the Group & Show Detail > Group
I get a "Cannot group that selection" pop up message.

I'll give the other tips a shot, I'm sure those will work.
thanks again
 
If the date column contains text, or blank cells, you'll see that
message. Maybe you included some blank rows at the end of the source
data range.
 
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 dates in pivot table 3
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Cannot Group that Selection error in PivotTable 1
The PivotTable field name is not valid (error) 1
Difference column in PivotTable 1
Group Dates from SQL Query 1
Pivottable - use same source data, and group data differently 1
Report Filter in PivotTable 1

Back
Top