A Pivot Table is a special tool in Excel for summarizing data without formulas.
The screen below shows the how fields have been configured to build the pivot table shown above.
Pivot tables automatically group data using field values.
For more details and examples, seeExcel Pivot Tables.
