Mark Shrigley's Test Lab

  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