Introduction

Pivot Tables and Charts are used to summarize data in multiple dimensions.

For example, in the following report, we may want summarize the promotional discounts of the books based on the name of the book and whether it's available online or not. This can be represented in a pivot table:

Pivot Tables and charts are based off of a report. The data for a pivot is obtained from the report.