Chapman Realty Company is seeking your help in analyzing the performance of its realtors over the last four months. During this time period the company's 12 realtors sold 99 properties (residential, commercial, and land) across six counties for a total of $30,637,161. Click here to download the Excel template, which you will use to answer the questions that follow Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel. 2c. Which realtor had the highest sales within each property type? In each case, how much did the realtor sell? Answer is not complete. Commercial David Wills Sold $ 5,929,019 Land Mitch Davis Sold Residential Mitch Davis Sold