Pivot tables

+ Unusuala contains inmormation about sanes or makeup products. Create rivor Tavies to compie une s following information s 1) The total units sold by product. (Table 1) 3 pts 2) For each Location the total revenue in sales. (Table 2) 3 pts 3) Total revenue by Salesperson and by Location (Table 3) 5 pts 3 4) Total revenue by salesperson and year. (Table 4) 5 pts 5) Create a Pivot chart for #4. 4 pts (1 pt of this is discretionary based on whether your chart best way). 0 1 O Tablet 0 Table2 O Table 3 0 Table 4 Chart 3 points 3 points 5 points 5 points 4 points Trans Number Name Betsy Hallagan Ashley Hallagan Zaret 0 1 2 3 I prefer that you put all of the pivot tables and the chart on the same tab. Create your first Pivot Table on a new sheet. Then create the subsequent ones by using existing location, and point to a cell below the first pivot table, and so on. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Date Product 4/1/2015 lip gloss 3/10/2015 foundation 2/25/2016 lipstick 5/22/2017 lip gloss 6/17/2015 lip gloss 11/27/2016 eye liner 3/21/2015 eye liner 12/17/2017 lip gloss 7/5/2017 eye liner 8/7/2017 lip gloss 11/29/2015 mascara 11/18/2015 lip gloss 8/31/2016 lip gloss 1/1/2016 eye liner 9/20/2017 foundation 4/12/2015 mascara Units 45 50 9 55 43 58 8 72 75 24 43 23 49 18 -8 45 Colleen Cristina Colleen Ashley Betsy Ashley Ashley Emilee Halagan Zaret Emitee Dollars Location 137 20 south $ 152.01 midwest $ 28.72 midwest $ 167.08 west $ 130.60 Midwest $ 175.99 midwest $ 25.80 midwest $ 217.84 midwest $ 226,64 south $ 73.50 easi $ 130.84 cast $ 71.03 West $ 149.59 West $ 56.47 south $ (21.99) cas! 137 39 cs! 5 26 88 9 0 11