Part IV: Managing and Analyzing Data
FIGURE 30.29
These three tables will be used for a PivotTable, using the data model.
The example in this section is available on this book’s website at http://www.wiley.com/go/excel
2019bible. You can use the workbook named data model.xlsx to follow along with the exam-
ple. The workbook named data model complete.xlsx shows the final PivotTable.
A PivotTable created using the data model has some restrictions, as opposed to a PivotTable created from a single
table. Most notably, you can’t group items or create calculated fields or calculated items.
For this example, the goal is to summarize sales by state, by region, and by year. Notice
that the sales and date information is in the Orders table, the state information is in the
Customers table, and the region names are in the Regions table. Therefore, all three tables
will be used to generate this PivotTable.
