Microsoft Office Tutorials and References
In Depth Information
Understanding the Internal Data Model
Figure 17-10: Start a pivot table and opt to choose an external connection.
Figure 17-11: Select the Tables in Workbook Data Model option to use the internal Data Model as the source for
your pivot table.
After you create the pivot table, you’ll see that the Pivot Field list shows each table in the internal
Data Model (similar to Figure 17-12).
Figure 17-12: Pivot tables that use the internal Data Model as the source will show all the tables within the Data
Model in the pivot field list.