Please help me find each part of this question.
B C D E Date Region COGS Sales 10/7/17 SouthEast Luke Home Depot Item $3,641.63 $6,278.08 10/26/17 West Jed Walmart Item $3,188.92 $7,416.09 5/20/18 North Home Depot Item $3,636.08 $6,269.11 9/24/17 Midwest Jon Whole Foods Item $2,982.53 $5,422.79 McLendon's Item $6,385.73 $6,829.66 1/14/18 Midwest Steven 4/3/17 West Sheladaan Whole Foods Item $1,174.98 $2,611.06 Jeri Nature Company Item $2,790.65 $4,811.47 1/20/18 NorthEast 2/26/17 SouthEast Jed Home Depot Item $15.06 $22.15 12/16/18 Midwest Jen Amazon.com Item $7,221.70 $8,208.48 Jed Costco Item $4,647.29 $8,449.61 4/5/17 NorthEast 1/24/18 NorthEast Jed Yahoo Item $1,264.48 $2,143.19 Chin Women Item $3,605.87 $6,111.65 8/22/17 SouthEast 11/9/17 NorthEast Luke TTM Item $203.69 $271.58 Rhonda Costco Item $944.41 $2,552.46 3/23/17 Midwest 10/3/18 Midwest Truong McLendon's Item $9,189.78 $9,820.64 4/4/17 Midwest Rhonda The Economy Item $3,918.36 $4,452.60 Luke Yahoo Item $241.66 $322.21 1/5/18 NorthEast 11/6/17 NorthEast Luke Nature Company Item $563.56 $1,024.66 1/25/18 SouthEast Costco Item $1,503.71 $2,004.95 Chin Solar and Wind Item $3,504.65 $8,150.30 11/12/17 Midwest Jed Excellent Variety Item $3,845.55 $6,991.91 12/7/10 West 11/5/17 Steven The Economy Item $2,510.19 $5,837.60 10/1 NorthEast Jed Amazon.com Item $627.94 $923.44 2/7/17 NorthEast Chin The Economy Item $1,441.14 $2,442.61 1/18/10 NorthEast Rhonda VCN Item $2,991.77 $3,999.02 Truong Excellent Ventures Item $7,657.57 $8,701.78 2/19/17 North Jen Home Depot Item $3,140.58 $5,414.79 12/11/18 North Chin Costco Item $558.25 $1,298.25 3/17/17 NorthEast Sheladaan Home Depot Item $730.54 $1,238.20 12/1/18 North 5/17 NorthEast Nature Company Item $4,007.99 $4,554.53 Chin 3/4/10 Midwest Excellent Ventures $5.24 $5.71 $5.61 Luke Jed Nature Company Item $1.85 $4.61 $4.31 5/19/17 West Luke Whole Foods $4.66 $2.35 $6.85 4/25/18 North Luke Yahoo Item $1.26 $7.40 $2,304.36 9/24/17 West Chin $0.30 $5.00 $9.27 Q2 Q3 Q4 Q5 Q1 Ready Accessibility Investigate
Part A Create a pivot table on this sheet that sums the sales for each month in each year, and shows the sales for each month as a percentage of the total sales Question #1 - Pivot Tables Part B - add a slicer for the region Part C - Create a second pivot table on this sheet that sums the COGS for each Sales rep Part D - Connect the slicer to this second pivot table
Q6
Q7
1+
100%