Grouping by range in a PivotTable groups numeric values into intervals of a chosen width, with a start and an end value. It is used to build distributions, such as age or amount ranges, without adding a column to the source.
Example
Group the Âge column by 10: 20-29, 30-39, 40-49.