This post demonstrates how to merge two related tables before creating a pivot table. A pivot table is limited to one table (data source) and I want to calculate the sales figures for each salesperson. The table to the right shows the product, price and the company.
The table to the left shows the salespersons and their companies. A salesperson may have multiple companies.