Go to the Product Types worksheet. Lucia wants to compare products sold by category and vendor. This data is stored in the Sales and Products tables. Create a PivotTable as follows that provides the products sold by manufacturer information for Lucia:
In cell B2, use Power Pivot to insert a PivotTable in the Product Types worksheet.
Use the following fields in the PivotTable:
· Vendor field from the Products table for the row headings
· Category field from the Products table for the column headings
· ItemQty field from the Sales table for the values