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. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-07-08T12:15:11+00:00

    Do not select multiple or all age cells.

    Instead, right-click a single age cell and select Group... from the context menu.

    You should then see a dialog to specify the start and end values and the group size.

    0 comments
  2. Anonymous
    2020-07-08T12:28:23+00:00

    Hi Hans,

    There must be something else wrong, because when I do that it gives a message that I cannot group that selection... I however opened my original spreadsheet I sent and there it works perfectly.

    3 people found this answer helpful.
    0 comments
  3. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-07-08T14:18:31+00:00

    Are you sure that the values in the source range are 'real' numbers, and not text values that look like numbers?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2020-07-08T14:34:17+00:00

    Hans,

    I've checked it and it was 'genera'l, which would not be a problem, but for good measure I changed it 'numbers' and made no difference...

    I sent the spreadsheet to the end-user and when she sent it back for additional pivotCharts I saw the grouping is not working.

    I have updated my original Spreadsheet with the additional pivotcharts and it is working like a Swiss clock. So, I decided to write it off as an unexplained anomaly and move on...

    Thanks for your effort, it is greatly appreciated!!

    Regards,

    Tjaart

    0 comments
  5. Anonymous
    2020-07-10T02:28:04+00:00

    Hi Tjaart,

    Thank you for sharing your experience here.

    According to your description, it seems that you cannot use Group Selection in Pivot table. And you encountered an error message. And it seems that you have changed the format of those numbers to Number format. However, the same problem still persists.

    If you sent the sheet to the others, then the others sent it back to you, the Group is not working. And you have updated your original spreadsheet, you found the additional pivot chart work fine.

    If so, it seems that this problem didn’t occur for now. I am writing to confirm if you need any help.  Let us know when you have time.

    Best Regards,

    Sukie

    0 comments