Share via

Group function in PIVOT table not working as intended

Anonymous
2020-07-08T11:52:48+00:00

Goad day,

I am trying to group age data, but when I group it, It doesn't give me the option to choose grouping intervals, etc. it only adds a line and says Group 1, but doesn't group the data.

Please assist

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-12T23:58:38+00:00

    Hi all,

    I have just encountered the same problem as above. I do not have the option to choose how to group. If i select all of the data cells from the pivot table, it will only create "Group 1" and does not give the option to break down dates by year or month as my previous work sheets have done so. I do not know how to proceed from here, i tried to re-create a new pivot table in the same workbook but it is still the same result. I tried to copy from an older workbook and as soon as i pasted the pivot table, it reverted to the  new non grouping format.

    2 people found this answer helpful.
    0 comments
  2. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2020-07-13T00:18:35+00:00

    Hi,

    Share the link from where I can download your workbook.

    0 comments