Thread: [Solved] Cannot Group Date In Excel Pivot Table
View Single Post
 
Old 01-18-2022, 07:33 AM
tomohawk tomohawk is offline Windows 10 Office 2019
Advanced Beginner
  
Join Date: Sep 2020
Location: Dublin
Posts: 48
tomohawk is on a distinguished road
Default 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
Attached Files
File Type: xlsx Cannot_Group_Pivot_Field.xlsx (46.9 KB, 5 views)
Reply With Quote