One kind of automatic grouping works on numeric data.
Lets take a look.
This pivot table shows total sales and orders for the sales data weve looked at previously.
One field we havent looked at yet is Quantity.
Lets break down total sales by order quantity.
To start off, lets add quantity to the pivot table.
When we first add the quantity field, we get a detailed breakdown by quantity.
This is interesting, but not very useful, since theres far too much detail.
Lets group the quantity field into larger buckets.
Excel will display a grouping dialog box, customized for numbers.
By default, Excel will have already filled in the lowest value and the highest value in the field.
In this case, lets group by 500.
When grouping by number, you’re able to adjust the grouping at any time.
Just select a value in the grouping field, right-click, and choose Group from the menu.
For example, we can easily set an upper limit of 1000 on our grouping.
Excel will then group all orders with a quantity of more than 1000 in a single group.
To ungroup a field, just choose Ungroup on the ribbon.
you might also right-click to group and ungroup a field.
Just select a value in the field, and right-click to access grouping commands.
