About this tutorial:
Video duration: 6:27
Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables to the PivotTable Field list and drag and drop fields, the Auto Detect Feature can build your Relationship for you. See how to create two Excel Tables, Add to Data Model using Create PivotTable Field list, drag and drop field and create Relationship between the two Products Field using the Auto Detect Relationship feature.