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 the most profitable items and characters. You have imported the sales data from a database into Excel, and will use it to create a PivotTable report to summarize your findings.

Answer rating: 100% (QA)

Heres how you can create a PivotTable report in Excel to analyze your Marvelous Merchandise Divisions weekly sales data and identify the most profitab... View the full answer