Right now Excel is suggesting you group the items in multiples of ten starting at the Starting value. As the Order ID is a numerical field the dialog will be already configured for numerical grouping with a Starting At, an Ending At and a By value. To do this, right click one of the Order IDs in the PivotTable and choose Group. In this PivotTable each individual OrderID is represented in one row of the table, this is summarized data but not highly so. Right now there is one row for each order which is cumbersome - we can group these to simplify the table. So, consider this example where the Order ID is a row label and a numeric field. You can summarize the invoices by grouping the invoices together into groups of 5,10 or even 100 invoices.

This can be done by grouping the data and in this post I'll explain how to do this. When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. Helen Bradley explains how to group data in Excel PivotTables to help further summarize and analyze your data.