how to show data of 3 table in pivot

how to show data of 3 table in pivot

 

Based on engineer name i want to get the data from 3 different tables like Service , amc, installation , but Every table contain Engineer name As Common , based that from the service table i want to take service amount , and count of service based on person, from the amc table i want to take layout type amc want to coinsder , gross amount, amc based on person, form installation table installation count based on person