Problem
Ivanhoe Inc. is a consulting company analyzing the pizza industry for an upcoming article. It has the following information on sales revenues: Company Product Revenue Pharoah Time Pizza $58,800 Michael's Pizza Pizza 82,300 Barbara's Pizza Pizza 95,200 Jennifer's Pizza Pizza 132,300 Pharoah Time Wings 48,500 Michael's Pizza Wings 112,900 Barbara's Pizza Wings 77,400 Jennifer's Pizza Wings 23,000
Using a pivot table in Excel, determine the market share (percentage by total revenue) of each company based on product type.