Excel Magic Trick 1151

Get Two Tables Into Pivot Table Field List using Excel 2013

DESCRIPTION

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




Be the first to comment

Leave a Reply