Pivot tables

Hello Amy

Thank you for your question and welcome to the forum.

A pivot table allows you to take data stored in a list/database and view the data in a tabular format. It allows for further breakdown/analysis of data over and above what you can do when the data is in a series of columns (e.g. applying subtotals).

To create a pivot table from a database, click in the database and go to Data - PivotTable and PivotChart Report and follow through the 3 step wizard to create a pivot table (or chart).


Kind regards
Amanda