Share via

Why cant I create class intervals

Anonymous
2023-09-12T05:25:10+00:00

Im new to excel and Have this pivot table where Im trying to put the Sum of Profit into class intervals and when I put them into rows and group, I dont get the grouping screen.

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-12T21:02:47+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    Group by profit intervals.

    My Table1 might be a previous PQ Query.

    Share raw data if not sure.

    With PivotChart and Slicer.

    https://www.mediafire.com/file_premium/sxc2sew8o98ylur/09_12_23.xlsx/file

    https://www.mediafire.com/file_premium/9txr3b3xnvuifcn/09_12_23.pdf/file

    Was this answer helpful?

    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-09-12T07:06:59+00:00

    Grouping is only possible for fields in the Rows or Columns section.

    https://support.microsoft.com/en-us/office/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725

    Numerical fields support different group types, select one item, right-click and choose Group.

    If you want to group non-numerical fields, you have to select the items for one group, then right-click and choose Group.

    Andreas.

    Was this answer helpful?

    0 comments