Pivot tables

Hi Pam,

Thank you for your question.

A pivot table is a tool used to analyse large amounts of data arranged in columns.

There are four areas of a pivot table, the Page Area, Row, Column and Data.

You select fields for each of the areas and then analyse the data.

If you had Name as the row heading, car as the column heading and salary as the data field, where the name intersects with the car, the cell displays the salary for that person driving that car.

I hope this helps.

Regards

Simon