Edit the PivotTable as follows to provide this information for Lucia:
- Edit the PivotTable as follows to provide this information for Lucia:
- a. Use the following fields from the 2021_Orders table in the PivotTable:
- · Material field for the row headings
- · SiteCity field for the column headings
- · ItemQty field for the values
- b. Use Products Sold as the custom name of the Sum of ItemQty field.
- c. In cell B3, use Product Material to replace "Row Labels", and then resize column B to its best fit.
- d. In cell C2, use Locations to replace "Column Labels".
mentalmavens asked a year ago
