You are the manager of Marvelous Merchandise Division and are analyzing weekly sales data that are reported by Hero, sales, and item. To plan production for the upcoming year, you want to determine which items and characters are selling the most. You have imported the sales data from a database into Excel, and will use it to create a PivotTable report to summarize your findings. 1 In a new worksheet, create a PivotTable report to analyze the number of weeks in which there were sales, and weekly Sales by Hero. Name this tab "Item Analysis." 2 HINTS: Value Field Settings can be set to COUNT instead of SUM. Check the pull down! Remember to add Hero to the table. 3 Move the new sheet immediately after this sheet. 4 Properly format values and column headings for clarity. 5 Add Sales to the Pivot as a summed value. 6 Bold the name of the Hero who had the highest total sales (Count of Sales) for each Item. 7 Highlight the cell of the item which resulted in the highest sales (Sum of Sales) for each Hero. 8 Save your work