Group PivotTable Values by Number Range in Excel for Mac
Question details
Group numeric PivotTable data into ranges in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user wants to organize scores, sales amounts, or other numeric data into intervals in a PivotTable.
- Observed behavior
- The Group command is not available when the numeric field is placed only in the Values area.
Check that the source column contains numeric values and note the interval you want to use. Open the PivotTable Fields pane so you can change where the field appears.
Move the numeric field to Rows or Columns and group it
Use this method to create number ranges directly in the PivotTable.
In the PivotTable Fields pane, drag the numeric field to Rows or Columns. A field cannot generally be grouped while it is only in Values.
In the PivotTable, right-click or Control-click a number in the field you placed in Rows or Columns, then choose Group.
In the Grouping dialog, enter the Starting at and Ending at values and the interval in By, then select OK.
Drag the numeric field into Values as well if you want a calculation for each range. Open the field's Value Field Settings to choose Sum, Count, or another calculation.

Create range labels in a source-data helper column
Use a helper column when PivotTable grouping is unavailable or you want to define ranges in the source data.
Group numeric data with a helper column in WPS Spreadsheets
Create interval boundaries in your source data, then use them as row labels in a WPS Spreadsheets PivotTable.
- 1. Open the workbook: Open your spreadsheet in WPS Spreadsheets and locate the numeric source column.
- 2. Create interval boundaries: Add a Range column and enter =INT(A2/10)*10 in the first data row, replacing A2 with the numeric cell. Copy the formula down the column.
- 3. Insert a PivotTable: Select the source data, including the new Range column, and choose Insert > PivotTable.
- 4. Arrange the fields: Drag Range to Rows and the numeric field to Values. Choose Count or another calculation for the Values field.

Frequently Asked Questions
Why can't I group a field in the Values area?
The Values area contains summarized calculations rather than row or column labels to group. Drag the original numeric field to Rows or Columns, then right-click a number and choose Group.
Can I count scores in each number range?
Yes. Group the score field in Rows, add the same field to Values, and use Value Field Settings to select Count.
What should I check if Excel still won't group the numbers?
Check the source column for blanks or text mixed with numbers, then refresh the PivotTable. If the data source does not support grouping, add a range helper column and use it in Rows.
How do I change the size of a numeric range?
When grouping a row or column field, enter the desired interval in the Grouping dialog's By box. For a helper column, change the interval in the formula, fill it down, and refresh or rebuild the PivotTable.




