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.