I have a large database with many fields of data. For my question i need 3 of them. a) Company name b) paid salary c) number of employees. I need to calculate the average wage of companies but i need to weigh them all to equal size as some are very large with low wages and some very small with high wages. I don't need the average wage but average wage of companies. The database has many other variables so one company can be on 1 or more rows. I need a formula for pivot formulas that would sum all companies by name calculate their average wage and then calculate the average of the average company wages.

Is it possible?