Pivot table
Summarize your records in a pivot table
When you have a table with lots of numbers that need summarizing, when you want to compare subsets of records, or when you’re trying to find trends, a pivot table is your best friend.
A pivot table is a versatile tool that helps you summarize the information in a table by slicing and dicing it so you can look at it from different perspectives. It works by grouping records together based on either one or two fields, and summarizing the data from those records, either by counting the number of records per group, or by using a specific summary function (like sum, average, or maximum) on another field.