Use this a pivot table to calcuate the number of total sales revenue, total profit and average profit margin for each product category:

Product Category	Sum of Quantity	Sum of Equipment Cost	Sum of Sale Amount
Bar Equipment	510	11504.3726	31277.3
Commercial Appliances	730	143395.992	218123.25
Concession Equipment	352	155565.7424	240188.6
Fryers	1874	44151.6007	73716.1
Ovens and Ranges	605	491640.5884	645171.45
Refrigerators and Coolers	457	457926.0049	675414.5
Warmers	395	431708.5537	467847.3
Grand Total	4923	1735892.855	2351738.5