Microsoft Office Tutorials and References
In Depth Information
Figure 18-47: This custom list ensures that the Region names are sorted correctly.
Using the Data Model
This chapter, so far, has focused exclusively on pivot tables that are created from a single table of data. A new
feature in Excel 2013 — Data Model — brings new power to pivot charts. With Data Model, you can use mul-
tiple tables of data in a single pivot table. You will need to create one or more “table relationships” so that the
data can be tied together.
Figure 18-48 shows parts of three tables that are in a single workbook (each sheet is in its own worksheet and is
shown in a separate window). The tables are named Orders, Customers, and Regions. The Orders table contains
information about product orders. The Customers table contains information about the company's customers.
The Regions table contains a region identifier for each state.
Notice that the Orders and Customers tables have a CustomerID column in common, and Customers and Re-
gions tables have a State column in common. The common columns will be used to form relationship among