Pivot Table with Average Values and Sum Totals

Hi there,    I have an issue displaying information in my pivot table where I have parent companies and their subsidiaries.    The revenue reported is at the Parent Company level so has been ente...