Pivots & Formula and copare tables

Hi there - my first post & hoping you can help me.

Say I have 2 Pivot tables on a worksheet listing (its for Umpires)

Base Umps

Names # games $ Pay
Fred 2 50
Sally 1 25
George 1 25


Home plate
Names # games $ pay
Fred 1 30
George 2 60
Tom 4 120


**** Question how do I create another table to compile the data of what is owed each person (list only once) - such as:

Name Games $
Fred 3 80
Sally 1 25
George 3 85
Tom 4 120

I cant figure this out ! =)

thanks !

Welcome,
The best use Power Query and connect data to one table and then create a PivotTable