Pivot tables

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.