Question

Go to the Manufacturers worksheet. Jacob wants to compare products sold by category and manufacturer. This data is stored in the purchases and products tables. Create a PivotTable as follows that provides the products sold by manufacturer information for Jacob.

a. Drag the "Category" field to the Rows area.
b. Drag the "Manufacturer" field to the Columns area.
c. Drag the "Product" field to the Values area, and choose to display it as "Count of Products."
d. Filter the PivotTable to show only Jacob's purchases.

Answer 1

To create a PivotTable that provides the products sold by manufacturer information for Jacob, follow the steps provided.

To create a PivotTable that provides the products sold by manufacturer information for Jacob, you need to follow these steps:

Go to the Manufacturers worksheet.

Drag the 'Category' field to the Rows area.

Drag the 'Manufacturer' field to the Columns area.

Drag the 'Product' field to the Values area and choose to display it as 'Count of Products.'

Apply a filter to the PivotTable to show only Jacob's purchases.