Create a PivotTable to show the price per unit for each transaction. Insert the PivotTable on the Transaction worksheet. Place Trans Number 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 per transaction. Add a calculated field named "PricePerUnit" (without the quotes) to show the price per unit for each transaction.