#1
|
|||
|
|||
Cannot Group Date In Excel Pivot Table
In the attached pivot table, I select the date field and right-click and select Group (I want to display either year or alternatively month.
I get a message "Cannot Group That Selection" In the File/Options/Data settings, the "Disable automatic grouping of Date/Time" option is unticked. Tommy |
#2
|
|||
|
|||
My bad!
Base data had 2 different formats for dates 🤦*♂️ |
#3
|
||||
|
||||
It's because the the dates in the source data rows 269 and below are not real dates but strings which look like dates. In the attached I've converted them to real dates (using Text-to-Columns) and grouped the dates in the pivot table by years and months.
|
#4
|
|||
|
|||
Thanks p45cal
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Issue With Date In Pivot Table | tomohawk | Excel | 6 | 01-18-2022 08:42 AM |
pivot table group by | HFLO | Excel | 0 | 06-08-2017 08:29 PM |
Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Group Date by Quarter in PIVOT TABLE | shilabrow | Excel | 6 | 04-24-2014 10:44 AM |
Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |