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
There is a duplicate row of a president (showing below), I'm going to remove it by selecting the DATA menu and then selecting the Remove Duplicates icon.