"Assignment Instructions

You are given information about the sales of makeup products. For each transaction, you are given the following information: Name of the Salesperson, Date of Sale, Product Sold, Units Sold, Transaction Revenue

Create a Pivot Table and Provide the following information

$1.$ The # of sales transactions for each salesperson

$2.$ For each salesperson, the total revenue by product

$3.$ Total Revenue generated by each salesperson, broken down by location

$4.$ Total Revenue by salesperson and year $($Hint: You need to group the data properly first$)$

For each question above, make sure you provide the appropirate information. This may require you to change the pivot table each time in a different view to get the answer. After you are done, save the tab with all these answers as $""$Problem $2\_$Solution"""