Add a pivot table

1. Open the Intelligence Center.
2. Click the Models tab, and then click a model to open it.
3. Click + Add Table and select Add pivot table from the menu.
4. In the Add pivot table dialog, click a table or table series as the data source for the new table.
5. Click Continue.
6. In the dialog, select a column sequence from the source table/series and the start year, including the number of years to include.
7. Click Complete.

The Table Properties panel includes the following key fields:

Field name	Description
Start year	Select the start year for the time series.
# of years of data to include	Select the number of years from the series to include in the table. The number of years includes the start year.

NOTE: You cannot add columns, measures, or folders to pivot tables.