rankan sanoe ompany has several plants located around the United States. The company's contas imported cast (Click the icon to view the Excel worksheet) Read the requirements 1. What was the total sales revenus for each product group? Choose the fields, any that you would add to Plot lable report try using the dropdown in each report for the Vatni afad laju of area of the report doen wat ned any Pivot tabo Sads, leave the input elds apts) Rows Columns Values What type of calculation you would use to summarize the value Data table Choose the fields. any that you would 2. What was the total sales revenue for each product grup by plane? w of the report does not owed any Piattati els ve Patable report by using the dropdown list i 3. 4 Filters Rows Columns Values What types of calculation you would o to summarize the value field 3. What was the average cost per unit for each canoe mod D A Park " JON 1 235 JOR HE M 15 A 1348 LAN ME 319 Cow A6