A PivotTable (tableau croisé dynamique, TCD) is a tool that summarizes a large volume of data into a summary table that you rearrange by drag and drop. It groups, counts, sums or averages values according to chosen fields, without writing a formula. It is built from a source in list format.
Example
Sum of amounts with regions in rows and quarters in columns.