Pivot Table

Hi Lars

Thank you for your question

A pivot table is a powerful tool for analysing database style information in multiple dimensions.

First the data must be in the form of a list, with column headings and no row headings. It is then possible to use a pivot table to analyse relationships between the different data items

For example if you have a database with the following column headings

SalesPerson
Customer
Date
Sale Value
Customer Type

You could use a pivot table to show how much was sold by each sales person, to each customer on a monthly basis.

Hope this helps

Regards

Stephen