Pivot Tables and Charts are used to summarize the 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 on a report. The data for a pivot is obtained from the report.