Get Two Tables Into Pivot Table Field List using Excel 2013
See how to Get Two Tables Into Pivot Table Field List using Excel 2013 to create a Report based on Revenue from one table and Category from a second table.
(00:08) Why you would need two tables in Pivot Table Field List
(01:10) Convert data to Excel Table
(01:30) Insert PivotTable and More Tables Button to add second table to Field List. This step adds first table to Data Model.
(02:25) Drag and Drop Fields From Two Tables
(02:33) Create Relationship between two tables (to simulate VLOOKUP). This step adds the second table to the data model.
(03:59) Add Number Formatting without PowerPivot
(04:25) Discussion about how the PivotTable from Data Model is different from PivotTable create natively in Excel