Date grouping issue pivot table - Excel

Mohammed Kasim 20 Reputation points
2024-07-01T12:38:35.7833333+00:00

I am encountering difficulties adding grouping to date columns in a PivotTable within the attached Excel file. When attempting to drag any date column to the row area, the expected grouping by month, year, or quarter does not appear. Manually clicking the group option also results in an error message stating "cannot add the group selection."

Interestingly, other users on different PCs can drag date columns to the row area and Excel automatically groups them by month, year, or quarter without issue.

but mine and that user excel version everything is same .

To troubleshoot, I tried changing the format of one date column on my PC from 03/14/2012 to 3/14/12 and recreated the PivotTable. This adjustment allowed automatic grouping when dragging the column to the row area, though this solution is inconsistent.

It appears that Excel or my PC settings may be causing the problem since other users can perform the grouping without adjustments.

excel sheet :

https://docs.google.com/spreadsheets/d/1OV3pIHeHAbU2bfNeXVpeySNqNIP3zRpw/edit?usp=sharing&ouid=102317795726055507687&rtpof=true&sd=true

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
    2024-07-03T01:47:15.95+00:00

    Hi @Mohammed Kasim

    Sorry, we are unable to access the files stored in Google. If conditions permit, you may save your file as .xml file, then try to upload it here.

    According to your description, I suggest you go to Control Panel > Clock and Region > Region > Formats, and then check the date formats.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments