Database Reference
In-Depth Information
Creating Pivot Tables
To create a pivot table based on the model, complete the following:
1. To create the pivot table, click the PivotTable drop-down on the Home
tab of the PowerPivot model designer (see
Figure 11.23
).
Figure 11.23
Adding a pivot table in Excel.
2. When asked, choose to create the pivot table in a new sheet. You should
see an empty pivot table with a pivot table field list that shows the tables
and fields in the PowerPivot model. Expand the flight_dept table node
and select the TotalDelays and AveDelay fields. Under the Carriers table
node, select the Description field. The pivot table field list should look
like
Figure 11.24
, and the pivot table should be similar to
Figure 11.25
.
