What is a Pivot Table?
A Pivot Table summarizes and tabulates large amounts of data in a condensed format. It is a cross tabulation summary table that can be arranged and rearranged to analyze data in many ways. Details of the data set can be displayed or hidden as seems most appropriate.
A Pivot Table data set can be summarized using functions like SUM, AVERAGE, and COUNT with totals and subtotals.
You can rotate a Pivot Table's rows and columns to see different summaries of the source data set.
A Pivot Table is a three dimensional summary table of a two dimensional data set.
A Pivot Table summarizes large amounts of information in a compact display.