In addition, you can’t create calculated fields or calculated items. The most notable one is: that you can’t create groups.

💡 Notes: A pivot table created using the Data Model has some restrictions when compared with a pivot table created from a single data table.

Similarly, for every row in the Customers table, there is exactly one corresponding row in the Regions table, and that row is determined by the State column. For every row in the Orders table, there is exactly one corresponding row in the Customers table, and that row is determined by the CustomerID column. Notice that the relationships between the tables are “one-to-many”. Read More: Creating an Excel Pivot Table Manually We shall use these common columns to form relationships among the tables. If you look at the tables closely, you will find that the Orders and Customers tables have the CustomerID column in common, and the Customers and Regions tables have the State column in common (download the working file to see the common things). The Customers table contains information about the company’s customers, and the Regions table contains regional information. The Orders table contains information about product orders. Every worksheet has a table, and we have also named these 3 tables Orders, Customers, and Regions (to keep it organized).

The worksheets are Orders, Customers, and Regions. Each worksheet is in the same workbook, just shown in a separate window. The following figure shows parts of three tables that are in a single workbook. Step-by-Step Procedures to Create a Pivot Table Data Model in Excel

Excel 2013 create pivot table