Pivot Tables

Hi Jen

Thank you for your question and welcome to the forum.

Pivot tables are generally used to be able to summarise or analyse data which is stored in a list/database (down columns in a spreadsheet).

When data is stored in a list, typically you will have each row detailing one individual item, e.g. a sale of an item - the item name, code, date of sale, store it was sold in, item amount.

With a pivot table you can summarise these sales, e.g. you can group together the sales for one product, for a particular store. Or you could look at sales by month or quarter, using the date of sale as a basis for this.

In a nutshell, the pivot table makes the data more flexible as you can look at the data in many different ways.

I hope this is useful.
Amanda