Pivot Table

 

Below is a regular table then a pivot table.  The pivot table has the retailer column that has the sum of Price per Unit column as well as the Sum of Units Sold.  

Retail Partners Table

Pivot Table