An alternative solution is to bring your two tables into Power Pivot and join them. Then create your pivot table.

https://www.myexcelonline.com/blog/l...s-power-pivot/