Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR

D

Dave K

Any idea why I continue to get the error message "CANNOT GROUP THAT
SELECTION ERROR" when I try to group a table by month using a Pivot
Table.

My data shows

Date Amount
1/1/08 100
1/4/08 150
2/3/08 225
2/8/08 300
Etc.

Previously I would just use the Grouping Option to group by month
(i.e., by right clicking in the date field within the pivot table, and
then choosing Group and Show Detail, then grouping by month.

But for unknown reason, I get the "cannot group that selection" error
when I click Group and show detail.

Any suggestions would be appreciated.

Thanks.
 
J

Jon Peltier

If there is anything in that column other than dates (stray text, even a
blank cell), then you cannot group the values. Took me a couple hours one
day to figure this out.

- Jon
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Grouping by month in a Pivot Table 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
pivot table data 2
Pivot Table - Group by Date Excel 2007 1
Grouping in a Pivot Table 1
grouping dates in a pivot table 1
Grouping daily transactions by month (using pivot tables), acrossyears 1

Top