MKU is a small makeup company in Chicago, IL. The company has hired you to summarize their sales data. The sales data is

[answerhappygod]

MKU is a small makeup company in Chicago, IL. The company has
hired you to summarize their sales data. The sales data is given in
the file ‘HW1-MKU.xlsx’. Each row in the excel file lists the
transaction number, employee name (salesperson), the product sold,
units sold and revenue generated. Answer the following questions
using by summarizing the sales data using the Pivot table or Pivot
chart.
a) What is the total revenue and units sold by each person for
each product? Provide managerial insights (e.g., top selling
products, best salespersons) using the Pivot table. Is this a
one-dimensional, two-dimensional or three-dimensional table?