\f2. Summarize each realtor's cumulative sales by property type for the four-month period: a. Using PivotTable, calculate the cumulative sales by property type for each realtor during the four- month period. b. Using PivotChart, create a bar chart that shows each realtor's cumulative sales of each property type during the four-month period If you could just provide the detailed steps of how to accomplish this in excel, that would be fine too. E F 1 Month Selling Price Type Realtor -1 RealtorID County October S 157,500 Commercial David Pullen 101 McDowell January 88,800 Commercial David Pullen 101 Rutherford November $7,875 Commercial David Pullen 101 Buncombe November 53,938 Commercial David Pullen 101 Rutherford October 2,989,500 Commercial David Willis 102 Buncombe November 2,027,375 Commercial David Willis 102 Henderson January 505,000 Commercial David Willis 102 McDowell January 242,500 Land David Willis 102 McDowell 10 January 236,300 Commercial David Willis 102 Polk 11 October 127,250 Residential David Willis 102 Polk November 108,125 Commercial David Willis 102 Buncombe 13 October 100,000 Land David Willis 102 Polk November 98,750 Residential David Willis 102 McDowell 15 January 64,400 Residential David Willis 102 Henderson 16 November 62,719 Commercial David Willis 102 Buncombe December $1,359 Commercial David Willis 102 Polk 18 January 44,258 Land David Willis 102 Henderson 19 October S 3,014,750 Commercial Hal Keefer 103 Rutherford January $ 717,000 Commercial Hal Keefer 103 Cleveland 21 October 585,000 Commercial Hal Keefer 103 Rutherford 22 December 288,422 Commercial Hal Keefer 103 Cleveland 23 November 272,625 Land Hal Keefer 103 Rutherford 24 December 204,469 Land Hal Keefer 103 Cleveland 25 November 83,625 Residential Hal Keefer 103 Polk 26 December 49,831 Commercial Hal Keefer 103 McDowell 27 November 47,500 Residential Hal Keefer 103 Cleveland 28 December 536,844 Commercial Jon Dolan 104 Mcdowell 29 January 81,117 Commercial Jon Dolan 104 Buncombe 30 December 50,158 Commercial Jon Dolan 104 Buncombe 31 January 45,680 Land Jon Dolan 104 Buncombe 32 December 41,875 Commercial Jon Dolan 104 Buncombe ms