Create a PivotTable to show the price per unit for each product.

Insert the PivotTable on the Product worksheet.

Place Product as the row labels.

Use an appropriate presentation of the Dollars and Units fields as the PivotTable values to display the total dollars and units for each product.

Add the PricePerUnit field you created in the previous task as a values field to show the price per unit for each product.