$7$: How do I create a PivotTable as follows that provides the products sold by manufacturer information for Jacob? $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 from the Products table for the row headings $-$ Category field from the Products table for the column headings $-$ ItemQty field from the Products table for the valuesSecurity Warning External Data Connections have been disabled Enable Content R $10*\backslash$times fx A c $[$ D E F G $]$ Lighting Designs: Products Sold by ManufacturerHome Insert Draw Page Layout Formulas Data Review View Automate Acrobat Table Q Tell me $\backslash$geoquad Comments P Security Warning External Data Connections have been disabled A$1$ A$\backslash$times f x OrderDate