Pivot Tables

A Pivot Table is a data summarisation tool that can automatically sort, provide totals or give the average of the data stored. A simple tip for Pivot Tables is to become familiar with the right-click menu (Remove Fields From Field Area is particularly useful).

Pivot Tables are discussed in more detail in the Results section of the online help.

Add

To create a Pivot Table:

  1. Right-click Pivot Tables in the Project Explorer and click Add:

  1. Give your Pivot Table a unique name:

View

To view a Pivot Table:

  1. Right-click the Pivot Table and select Open.

Edit

To edit a Pivot Table:

  1. Drag elements into the Pivot Table.

  2. Text type elements can be rows or columns.

  3. Numeric/date type elements are data items.

Using Areas in Pivot Tables

Areas are text type elements when used in a Pivot Table:

  1. Areas are in the collection of elements by default

  2. Used as a column

  3. Used as a row

Using Fields in Pivot Tables

Fields are numeric type elements when used in a Pivot table:

  1. Used in the Data Field area

  2. Dragged directly into the Data area