11 Review Later Pivot Table-Data.xlsx Please download and open the attached file. Round your answers to whole numbers, without the dollar symbol. in Hats generated 12 total in revenue, and pants generated revenue through Instagram. Shorts generated on average AdWords. in revenue through (channel) (product) costed the most in shipping costs and costed the most in marketing cost. Shipping Cost -5 -5 -7 -7 4 Marketing Cost -6 -2 -7 -5 4 -2 -2 4 Date 01/01/2018 01/01/2018 01/01/2018 01/01/2018 01/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 02/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 03/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 04/01/2018 Channel Linkedin Snapchat AdWords Facebook Snapchat AdWords Snapchat Facebook Facebook Snapchat Instagram Email Email Twitter AdWords Instagram Email Email Twitter AdWords Instagram AdWords Facebook Email Twitter Facebook Snapchat AdWords Facebook AdWords Snapchat Facebook Snapchat AdWords Instagram Instagram Linkedin Product T-shirt T-shirt T-shirt T-shirt Shorts Hat Shorts Pants T-shirt T-shirt Shorts Shorts Shorts Shorts T-shirt Hat Pants Hat Hat T-shirt Pants Shorts Hat Shorts T-shirt T-shirt Shorts Pants Shorts T-shirt T-shirt Hat Hat Hat Shorts Shorts Shorts Revenue 47 49 50 41 39 22 38 80 48 45 36 34 30 30 48 30 74 21 23 42 80 32 27 34 45 43 33 77 31 43 48 26 27 22 36 33 35 -1 -5 -7 3 -1 w w w do in do as to do in to two hdb w i do ~ ' w tot tot d as w do do 4 ~ db -7 -2 -1 -2 4 -7 -8 06/01/2018 06/01/2018 06/01/2018 06/01/2018 Twitter Linkedin Linkedin Snapchat Hat T-shirt Shorts Hat 30 43 33 28 -7 -7 4 -2 -6 0 3 -7 -2 -8 -6 3 -2 -7 06/01/2018 06/01/2018 06/01/2018 06/01/2018 06/01/2018 06/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 07/01/2018 08/01/2018 08/01/2018 08/01/2018 08/01/2018 08/01/2018 08/01/2018 08/01/2018 Linkedin Email Snapchat Snapchat Snapchat Linkedin Linkedin Twitter Email Instagram Twitter Instagram Twitter Twitter Facebook Linkedin Snapchat Email Facebook Email Twitter Email Twitter Twitter Snapchat Shorts T-shirt Pants Hat T-shirt Pants Pants Hat Pants Pants Pants Shorts T-shirt Shorts Pants Pants Pants Hat Hat T-shirt Shorts Shorts Hat Pants Shorts 32 41 72 28 49 74 72 20 79 74 75 35 45 38 78 72 71 27 22 40 32 40 27 74 37 t ~ ~ N in to w in a t ~ db to w do in w to w to w 4 4 -7 -3 -8 -7 -2 -7 -2 -1 -5 -2 -2 -2 4 -2 - 1 -7 -7 -6 -2 08/01/2018 08/01/2018 08/01/2018 08/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 09/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 10/01/2018 Snapchat Instagram Email Snapchat Email Facebook Instagram Snapchat AdWords Facebook Facebook AdWords Instagram Linkedin AdWords Instagram Shorts Pants Shorts Pants Shorts Pants Hat Pants Shorts Shorts Shorts T-shirt Pants T-shirt T-shirt T-shirt Hat Hat Shorts Pants Pants T-shirt Pants T-shirt Hat Shorts -7 -5 37 71 34 75 31 73 23 78 32 40 36 40 77 48 49 43 30 27 30 75 77 46 76 50 20 38 to w i do to i 4 t i to i to a to w to i to do so to i 4 db to do do i do do & do do d w w do to do W w do Email -5 -2 3 -1 -2 4 -7 -7 4 Linkedin Twitter Snapchat Instagram AdWords Facebook Instagram Snapchat Facebook -7 10/01/2018 Linkedin Shorts 32 4 -6