|
|
#1
01-18-2022, 07:33 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2019
Threaded Mode