$7.$ Go to the Manufacturers worksheet. Jacob wants to compare products sold by category and manufacturer.

Create a PivotTable as follows that provides the products sold by manufacturer information for Jacob:

a$.$ In cell A$2,$ insert a PivotTable in the Manufacturers worksheet based on the Products table you created.

b$.$ Use the following fields in the PivotTable:

$$ Manufacturer field for the row headings

$$ Category field for the column headings

$$ ItemQty field for the values