A pivot table is a tool that allows you to present data from an ordinary flat table in a form that is easy to analyze.
Pivot tables allow you:
•To quickly place data from the source table columns into the pivot table columns and rows and swap them around.
•To perform calculations.
•To filter data.