Excel Magic Trick 1268


Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List
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.


Be the first to comment

Leave a Reply