need a formulas to solve using excel
- J K L M N 0 P Q R S 7 0 TOTAL 15 points 0 Table 1 3 points 0 Table2 3 points 0 Table 3 4 points O Table 45 points 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. A B DE F G H 3 This data contains information about sales of makeup products. Create Pivot Tables to compile the 4 5 following information: 6 1) The total units sold by product. (Table 1) 3 pts 2) For each Location the total revenue in sales. (Table 2) 3 pts 8 3) Total revenue by Salesperson and by Location. (Table 3) 5 pts 9 4) Total revenue by salesperson and year. (Table 4) 5 pts 10 11 12 13 14 15 Trans Number Name Date Product Units Dollars Location 16 Bethany 4/1/2015 lip gloss 45 $ 137.20 south 17 2 Hallagan 3/10/2015 foundation 50 $ 152.01 midwest 18 3 Ashley 2/25/2016 lipstick 9 $ 28.72 midwest 19 4 Hallagan 5/22/2017 lip gloss 55 $ 167.08 west 20 5 Zaret 6/17/2015 lip gloss 43 S 130.60 midwest 21 6 Carla #*****### eye liner 58 $ 175.99 midwest 7 22 7 Cristina 3/21/2015 eye liner 8 $ 25.80 midwest 23 8 Carla #### lip gloss 72 217.84 midwest 24 9 Ashley 7/5/2017 eye liner 75 $ 226.64 south 25 10 Bethany 8/7/2017 lip gloss 24 $ 73.50 east 26 11 Ashley ##**### mascara 43 $ 130.84 east 12 Ashley **** lip gloss 23 $ 71.03 west 28 13 Emilee 8/31/2016 lip gloss 49 $ 149.59 west 29 14 Hallagan 1/1/2016 eye liner 18 $ 56.47 south 30 15 Zaret 9/20/2017 foundation 8 $ 21.99 east 31 16 Emilee 4/12/2015 mascara 45 $ 137.39 east 32 17 Carla 4/30/2017 mascara 66 $ 199.65 south 33 18 Jen 8/31/2016 lip gloss 88 $ 265.19 midwest 34 19 Jen ######### eye liner 78 $ 236.15 south 35 20 Zaret ######### lip gloss 57 $ 173.12 midwest 36 21 Zaret 6/2/2017 mascara 12 $ 38.08 west 37 22 Bethany 9/24/2015 eye liner 28 $ 86.51 midwest 38 23 Carla 2/1/2017 mascara 25 $ 77.31 midwest 39 25 26 Emilee 12/6/2017 lip gloss 24 $ 74.62 west 40 An 27 27 Jen 4/12/2015 lipstick 38 $ 115.99 midwest 41 28 Cristina 9/22/2016 foundation 77 $ 233.05 midwest 42 32 3/28/2017 lip gloss 53 $ 161.46 midwest 43 33 Cici 6/17/2015 mascara 41 $ 125.27 west 44 34 Zaret 9/9/2017 mascara 19 $ 59.15 west 45 39 Cici 2/23/2017 foundation 9 $ 24.63 west 46 40 Hallagan 6/24/2017 foundation 38 $ 115.58 south 47 41 Emilee 2/6/2015 eye liner 25 $ 76.56 south 40 48 42 Emilee 4/10/2016 mascara 19 $ 59.38 midwest 49 43 Bethany 4/1/2015 foundation 86 $ 259.86 west 50 44 Carla 6/6/2015 lip gloss 55 S 167.12 midwest 27 Cristina
