! Required information [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create a calculated field for the Gross Margin. 2. Create a summary table that shows the gross margin per customer. Ask the Question: Which customers are the most profitable? Master the Data: Fruitopia sells exotic fruit from throughout the world to customers throughout the country by mail order. The company keeps a sales journal that records each sale and its related sales and cost details. This sales journal is for March 1-4, 2021. Use data file Lab 2-4 Data.xlsx, but open in Tableau. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) This question will be sent to your instructor for grading. Prev 1 2 of 2 Next .......... bleau Lab 2.4 Saved Help Help Data: Lab 2-4 Data.xlsx. 1 Perform the Analysis: Refer to Lab 2-4 in the text for instructions and steps for each of the lab parts. Share the Story: Part 1: Upload Your Files Part 2: Assessment rt 1 of 2 nts Upload the Word or PDF document containing your Lab screenshots using the button below. Skipped Take a screenshot of your chart, and label it Lab 2-4 Submission Tableau.jpg." eBook Print eferences upload a response file (15MB max) Choose File No file chosen save O This question will be sent to your instructor for grading. w 2 JIIGI CLIC SLUI y. Part 1: Upload Your Files Part 2: Assessment Part 2 of 2 Required: 1. Which customer number is the least profitable with $4.80 gross margin? 5 points O 2024 0 2051 Skipped 0 2031 O 2043 eBook 2. Which "pill" do you have on the Rows shelf? Print O Gross Margin O Count(Customer #) O Customer # O Sum(Gross Margin) References 3. Which "pill do you have on the Marks card? O Customer # O Sum(Gross Margin) O Count(Customer #) O Gross Margin Tableau Lab 2.4 G Saved 2 Required information Part 2 of 2 3. Which "pill" do you have on the Marks card? O Customer # 5 points Skipped O Sum(Gross Margin) O Count(Customer #) O Gross Margin 4. What is the gross margin of customer 2070? eBook O 6.6 Print O 11.6 O 44.9 O 107.4 References 5. Swap Sum(Gross Margin) for Sum(Sales). What were the total sales for customer 2047? O 357.7 O 32.9 O 78.7 O 948.5 n File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you nee A2 X fx 3021 J A B D E F G | 1 Invoice # Customer # Zip Code Date of Sal SKU Description Quantity (Pound: Sales Cost 2 3021 2001 67510 3/1/2021 FRT-APL Apple 15 25.52 16.36 3 3021 2001 67510 3/1/2021 FRT-GOR Goji berry 5 5.92 3.71 4 3021 2001 67510 3/1/2021 FRT-OLV Olive 35 53.92 33.26 5 3021 2001 67510 3/1/2021 FRT-REN Redcurrant 5 5 7.12 4.26 6 3022 2091 67621 3/1/2021 FRT-FII Fig 35 84.37 54.26 7 3023 2021 67511 3/1/2021 FRT-JUR Juniper berr 50 65.02 43.01 8 8 3023 2021 67511 3/1/2021 FRT-PAY Papaya 35 37.12 22.06 9 3023 2021 67511 3/1/2021 FRT-BAN Banana 5 2.52 1.56 10 3023 2021 67511 3/1/2021 FRT-PEO Persimmon 35 69.67 43.06 11 3024 2079 66401 3/1/2021 FRT-SAM Satsuma 50 34.52 22.01 12 3024 2079 66401 3/1/2021 FRT-MII Miracle fruit 15 30.77 18.01 13 3024 2079 66401 3/1/2021 FRT-CHI Chico fruit 15 26.27 15.46 14 3024 2079 66401 3/1/2021 FRT-DUA Durian 25 54.27 33.01 15 3024 2079 66401 3/1/2021 FRT-BAN Banana 35 17.52 10.86 16 3025 2099 66710 3/1/2021 FRT-SAM Satsuma 30 20.72 13.21 17 3025 2099 66710 3/1/2021 FRT-ELR Elderberry 25 60.27 38.01 18 3025 2099 66710 3/1/2021 FRT-NAC Nance 5 5.92 3.61 19 3025 2099 66710 3/1/2021 FRT-BAN Banana 45 22.52 13.96 20 3025 2099 66710 3/1/2021 FRT-LEO Lemon 5 12.32 7.41 21 3025 2099 66710 3/1/2021 FRT-ORG Orange 50 37.52 24.51 22 3026 2088 67004 3/1/2021 FRT-CHY Cherimoya 45 78.77 49.96 23 3026 2088 67004 3/1/2021 FRT-ORG Orange 35 26.27 17.16 24 3026 2088 67004 3/1/2021 FRT-LOA Loquat 45 25.67 17.11 25 3026 2088 67004 3/1/2021 FRT-FII Fig 50 120.52 77.51 26 3026 2088 67004 3/1/2021 FRT-JAB Jabuticaba 50 44.52 26.01 27 3027 2087 67831 3/1/2021 FRT-MAR Marionberry 10 9.52 6.11 28 3028 2086 67416 3/1/2021 FRT-ORG Orange 15 11.27 7.36 29 3028 2086 67416 3/1/2021 FRT-COU Coconut 45 108.47 69.31 30 3028 2086 67416 3/1/2021 FRT-LOA Loquat 5 2.87 1.91 31 3028 2086 67416 3/1/2021 FRT-BAN Banana 40 20.02 12.41 32 3028 2086 67416 3/1/2021 FRT-MII Miracle fruit 35 71.77 42.01 33 3028 2086 67416 3/1/2021 FRT-APO Apricot 25 70.02 44.01 34 3029 2053 66402 3/1/2021 FRT-BOR Boysenberry 15 15.02 9.31 35 3030 2063 67010 3/1/2021 FRT-APL Apple 45 76.52 49.06 36 3030 2063 67010 3/1/2021 FRT-BIT Bilberty 40 80.02 46.81 37 3030 2063 67010 3/1/2021 FRT-DRI Dragonfruit 5 8.17 4.91 38 3031 2041 66404 3/1/2021 FRT-LYE Lychee 40 80.42 50.01 39 3031 2041 66404 3/1/2021 FRT-PUE Purple mang 40 40.42 23.61 40 2022 2069 67418 3/1/2021 ERT-TAN Tamarind 2012 82 27.61 Sheet1 I O Type here to search T. File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless yo A2 fx 3021 G H 1 39 40 41 42 3031 3032 3032 3033 3033 3034 43 44 45 46 47 3035 3036 3037 3038 3039 48 49 50 3039 51 52 53 54 3039 3039 3039 3039 3039 3039 3039 3040 3040 55 56 57 58 1 B 2041 66404 2068 67418 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66406 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2087 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67732 Sheet1 23.61 27.61 29.61 24.81 23.11 51.61 54.51 27.46 33.31 24.51 6.21 19.61 39.01 7.36 4.91 24.81 10.36 12.26 62.01 11.81 16.36 43.01 15.51 35.41 17.71 69.01 D E F 3/1/2021 FRT-PUE Purple mang 3/1/2021 FRT-TAN Tamarind 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-PLT Plumcot (or 3/1/2021 FRT-SAR Salal berry 3/1/2021 FRT-BLR Blackberry 3/1/2021 FRT-CUE Cucumber 3/1/2021 FRT-CRR Cranberry 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-ORG Orange 3/2/2021 FRT-PLI Plantain 3/2/2021 FRT-DRI Dragonfruit 3/2/2021 FRT-CHR Cherry 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SUL Sugar apple 3/2/2021 FRT-UGI Ugli fruit 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-PLT Plumcot (or 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-JUR Juniper berry 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-AVD Avocado 3/2/2021 FRT-TAN Tamarind 3/2/2021 FRT-APL Apple 3/2/2021 FRT-KUA Kumquat 3/2/2021 FRT-CUE Cucumber 3/2/2021 FRT-GOR Goji berry 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-JAB Jabuticaba 3/2/2021 FRT-PEA Pear 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-RAR Raspberry 3/2/2021 FRT-POT Pomegranat 3/2/2021 FRT-LIM Lime 3/2/2021 FRT-PAY Papaya 3/2/2021 FRT-BLR Blackberry 372/2021 ERT-EEO Faina 40 40.42 20 43.82 40 50.02 20 42.02 35 39.22 40 80.02 50 91.02 45 45.47 45 56.27 50 37.52 5 10.32 20 32.62 25 62.52 15 11.27 10 7.52 40 40.42 15 16.82 25 18.77 50 105.02 20 18.82 15 25.52 50 65.02 50 25.02 30 60.02 30 30.02 50 109.52 50 85.02 15 10.67 50 91.02 45 53.12 30 52.52 5 4.47 50 91.52 5 10.02 10 11.42 15 9.77 10 9.62 5 5.32 25 50.02 un 7922 3040 59 60 61 62 3041 3041 3042 63 64 65 66 67 68 69 3043 3043 3043 3043 3044 3044 3045 3045 70 71 54.51 6.76 54.51 33.31 31.21 2.61 53.51 6.46 7.01 6.31 5.71 3.16 32.26 72 73 74 75 76 77 79 3045 3045 3046 3046 3046 3046 2046 52.01 File Home Insert Draw Page Layout Formulas Data Review i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fic 3021 G H 1 3046 77 78 25 50.02 40 79.22 45 108.02 25 16.52 3046 3046 3046 79 32.26 52.01 65.71 11.01 10.66 80 81 15 17.27 82 35 15 17.52 7.52 83 3047 3048 3048 3048 3048 3048 3048 10.86 4.66 2.46 84 5 85 40 58.41 86 25 B 2064 67732 2064 67732 2064 67732 2064 67732 2070 67522 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2043 66840 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2098 67023 2036 67333 2036 67333 2032 66414 3.77 96.02 43.77 46.02 12.52 87 88 20 25 3049 3050 10 10.12 89 90 3050 15 7.52 91 3050 14.12 15 5 92 93 10 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 5.91 45.51 50.86 49.06 94 5 95 35 96 D E F 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-MUR Mulberry 3/2/2021 FRT-PEC Peach 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-RAA Rambutan 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-PUE Purple mang 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-YUZ Yuzu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-PLM PlumPrune 3/2/2021 FRT-PAI Passionfruit 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-JAU Jambul 3/2/2021 FRT-CLR Cloudberry 3/2/2021 FRT-DAO Damson 3/2/2021 FRT-BLN Blackcurrent 3/2/2021 FRT-PHI Physalis 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-PIL Pineapple 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-JUB Jujube 3/3/2021 FRT-JAI Jackfruit 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-CRR Cranberry 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-PEA Pear 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-APL Apple 3/3/2021 FRT-CLR Cloudberry 3/3/2021 ERT-STR Strawberry 3050 3050 3050 3051 3052 3052 3053 3053 3054 3054 3054 3054 97 10 35 45 98 99 2032 66414 45 25 100 101 102 103 104 10 40 33.51 11.81 44.81 22.41 16.11 40 35 3054 3054 7.52 17.02 6.57 32.92 9.42 69.32 87.77 78.77 51.02 20.02 72.82 37.62 26.97 20.02 59.62 9.47 23.72 45.47 73.52 82.97 54.92 22.52 17.02 70.02 2402 105 40 12.41 106 40 15 38.01 5.56 10 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2063 67335 2063 67335 2022 67925 Sheet1 45 3055 3055 3055 3055 3055 3055 3055 3055 107 108 109 110 111 112 113 114 115 116 50 35 15.41 27.46 48.01 53.91 32.11 13.96 10.91 30 45 10 3056 40 3056 2057 43.61 15.61 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 3021 A G 1 115 116 117 118 119 120 121 122 123 B 2063 67335 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 2055 67432 2055 67432 2046 67026 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2088 67631 2088 67631 3056 3057 3058 3058 3059 3059 3059 3059 3060 3061 3061 3061 3061 3061 3061 3061 3061 3062 3062 3063 3063 3063 3064 3064 124 43.61 15.61 6.61 8.81 7.11 4.66 22.81 10.31 31.06 4.66 29.51 44.41 16.36 29.61 19.61 4.91 25.21 9.91 18.31 H 40 70.02 30 24.02 5 10.87 20 13.22 10 11.52 5 7.52 15 36.17 10 17.52 45 50.42 15 7.52 50 50.02 40 70.02 15 25.52 40 50.02 40 30.02 10 7.52 40 38.42 15 16.82 30 28.22 10 14.72 5 3.57 15 29.87 15 34.82 50 40.52 20 15.42 45 33.77 25 45.52 15 30.62 10 7.72 50 85.02 50 100.52 30 44.72 5 12.52 20 46.22 2038 66725 D E F 3/3/2021 FRT-CLR Cloudberry 3/3/2021 FRT-STR Strawberry 3/3/2021 FRT-DUA Durian 3/3/2021 FRT-MUR Mulberry 3/3/2021 FRT-PEC Peach 3/3/2021 FRT-YUZ Yuzu 3/3/2021 FRT-ELR Elderberry 3/3/2021 FRT-CHI Chico fruit 3/3/2021 FRT-UGI Ugli fruit 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-AVD Avocado 3/3/2021 FRT-CHY Cherimoya 3/3/2021 FRT-APL Apple 3/3/2021 FRT-GRI GrapeRaisin 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-HUR Huckleberry 3/3/2021 FRT-SAR Salal berry 3/3/2021 FRT-PAI Passionfruit 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-KUA Kumquat 3/3/2021 FRT-PEO Persimmon 3/3/2021 FRT-KII Kiwifruit 3/3/2021 FRT-SAA Salak 3/3/2021 FRT-TAL Tamarillo 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-PHI Physalis 3/4/2021 FRT-DAO Damson 3/4/2021 FRT-PIL Pineapple 3/4/2021 FRT-APL Apple 3/4/2021 FRT-LYE Lychee 3/4/2021 FRT-JUB Jujube 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-PLI Plantain 3/4/2021 FRT-BLR Blackberry 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/1/2021 ERT-COR Goi berry 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 9.61 2.26 18.46 20.56 25.01 3065 3065 10.21 22.06 28.01 20.11 4.61 54.51 3065 3065 3066 3067 3067 3067 3067 3067 3067 3068 3068 3068 3068 2069 2038 66725 2038 66725 2006 67031 2006 67031 2067 67837 2067 67837 2067 67837 2067 67837 2047 66939 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2046 67035 2046 67035 2046 67035 2046 67035 2046 67025 Sheet1 40 30 82.42 60.02 62.51 28.51 7.86 29.41 49.61 38.71 2.86 9.81 59.21 5 20 4.82 15.02 98.42 4722 40 un 154 29 61 File Home Insert Draw Page Layout Formulas Data Rev PROTECTED VIEW Be carefulfiles from the Internet can contain viruses, A2 fx 3021 G H 1 J 2.86 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 A 3068 3068 3068 3068 3068 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3070 3070 3070 3070 3071 3071 3071 3072 3072 3072 3072 3072 3072 3072 3072 B C 2046 67035 2046 67035 2046 67035 2046 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2018 67342 2018 67342 2018 67342 2018 67342 2044 67042 2044 67042 2044 67042 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 D E F 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-STR Strawberry 3/4/2021 FRT-BIT Bilberty 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-RAR Raspberry 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-SUL Sugar app! 3/4/2021 FRT-APO Apricot 3/4/2021 FRT-BAN Banana 3/4/2021 FRT-DAT Date 3/4/2021 FRT-GRI GrapeRaisi 3/4/2021 FRT-MAR Marionbern 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-DAT Date 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-SAA Salak 3/4/2021 FRT-PLM Plum Prune 3/4/2021 FRT-RAA Rambutan 3/4/2021 FRT-APL Apple 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-REN Redcurrant 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-COU Coconut 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-NAC Nance 3/4/2021 FRT-KII Kiwifruit 3/4/2021 FRT-JAI Jackfruit 3/4/2021 FRT-OLV Olive 3/4/2021 FRT-JAU Jambul 3/4/2021 FRT-BOR Boysenber 3/4/2021 FRT-TAL Tamarillo 3/4/2021 FRT-HUR Hucklebern 3/4/2021 FRT-POT Pomegran 3/4/2021 FRT-CHR Cherry 5 4.82 20 15.02 40 98.42 40 47.22 5 2.87 35 28.02 50 100 10 19.42 45 46.37 40 45.62 40 37.62 35 80.87 25 25.27 50 140 40 20.02 5 4.17 50 62.52 35 33.27 20 15.02 15 12.47 40 30.02 35 28.37 10 13.12 20 46.02 20 34.02 5 5.17 30 58.22 45 33.77 15 21.32 30 75.02 35 84.37 40 37.62 10 11.82 5 2.87 40 47.22 20 46.42 20 12.62 10 15.42 40 78.02 50 50.02 35 26.97 5 4.82 40 26.02 5 5 12.52 9.81 59.21 29.61 1.91 18.21 58.51 12.01 28.36 28.01 23.61 51.46 15.51 88.01 12.41 2.71 37.01 21.36 9.81 8.11 19.61 17.51 7.71 30.41 21.81 3.16 36.01 22.06 12.76 47.11 53.91 23.61 7.41 1.91 28.81 27.41 7.41 9.51 45.21 31.01 17.86 3.16 16.81 7.81 Sheet1 ! Required information [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create a calculated field for the Gross Margin. 2. Create a summary table that shows the gross margin per customer. Ask the Question: Which customers are the most profitable? Master the Data: Fruitopia sells exotic fruit from throughout the world to customers throughout the country by mail order. The company keeps a sales journal that records each sale and its related sales and cost details. This sales journal is for March 1-4, 2021. Use data file Lab 2-4 Data.xlsx, but open in Tableau. Software needed Tableau Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) This question will be sent to your instructor for grading. Prev 1 2 of 2 Next .......... bleau Lab 2.4 Saved Help Help Data: Lab 2-4 Data.xlsx. 1 Perform the Analysis: Refer to Lab 2-4 in the text for instructions and steps for each of the lab parts. Share the Story: Part 1: Upload Your Files Part 2: Assessment rt 1 of 2 nts Upload the Word or PDF document containing your Lab screenshots using the button below. Skipped Take a screenshot of your chart, and label it Lab 2-4 Submission Tableau.jpg." eBook Print eferences upload a response file (15MB max) Choose File No file chosen save O This question will be sent to your instructor for grading. w 2 JIIGI CLIC SLUI y. Part 1: Upload Your Files Part 2: Assessment Part 2 of 2 Required: 1. Which customer number is the least profitable with $4.80 gross margin? 5 points O 2024 0 2051 Skipped 0 2031 O 2043 eBook 2. Which "pill" do you have on the Rows shelf? Print O Gross Margin O Count(Customer #) O Customer # O Sum(Gross Margin) References 3. Which "pill do you have on the Marks card? O Customer # O Sum(Gross Margin) O Count(Customer #) O Gross Margin Tableau Lab 2.4 G Saved 2 Required information Part 2 of 2 3. Which "pill" do you have on the Marks card? O Customer # 5 points Skipped O Sum(Gross Margin) O Count(Customer #) O Gross Margin 4. What is the gross margin of customer 2070? eBook O 6.6 Print O 11.6 O 44.9 O 107.4 References 5. Swap Sum(Gross Margin) for Sum(Sales). What were the total sales for customer 2047? O 357.7 O 32.9 O 78.7 O 948.5 n File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you nee A2 X fx 3021 J A B D E F G | 1 Invoice # Customer # Zip Code Date of Sal SKU Description Quantity (Pound: Sales Cost 2 3021 2001 67510 3/1/2021 FRT-APL Apple 15 25.52 16.36 3 3021 2001 67510 3/1/2021 FRT-GOR Goji berry 5 5.92 3.71 4 3021 2001 67510 3/1/2021 FRT-OLV Olive 35 53.92 33.26 5 3021 2001 67510 3/1/2021 FRT-REN Redcurrant 5 5 7.12 4.26 6 3022 2091 67621 3/1/2021 FRT-FII Fig 35 84.37 54.26 7 3023 2021 67511 3/1/2021 FRT-JUR Juniper berr 50 65.02 43.01 8 8 3023 2021 67511 3/1/2021 FRT-PAY Papaya 35 37.12 22.06 9 3023 2021 67511 3/1/2021 FRT-BAN Banana 5 2.52 1.56 10 3023 2021 67511 3/1/2021 FRT-PEO Persimmon 35 69.67 43.06 11 3024 2079 66401 3/1/2021 FRT-SAM Satsuma 50 34.52 22.01 12 3024 2079 66401 3/1/2021 FRT-MII Miracle fruit 15 30.77 18.01 13 3024 2079 66401 3/1/2021 FRT-CHI Chico fruit 15 26.27 15.46 14 3024 2079 66401 3/1/2021 FRT-DUA Durian 25 54.27 33.01 15 3024 2079 66401 3/1/2021 FRT-BAN Banana 35 17.52 10.86 16 3025 2099 66710 3/1/2021 FRT-SAM Satsuma 30 20.72 13.21 17 3025 2099 66710 3/1/2021 FRT-ELR Elderberry 25 60.27 38.01 18 3025 2099 66710 3/1/2021 FRT-NAC Nance 5 5.92 3.61 19 3025 2099 66710 3/1/2021 FRT-BAN Banana 45 22.52 13.96 20 3025 2099 66710 3/1/2021 FRT-LEO Lemon 5 12.32 7.41 21 3025 2099 66710 3/1/2021 FRT-ORG Orange 50 37.52 24.51 22 3026 2088 67004 3/1/2021 FRT-CHY Cherimoya 45 78.77 49.96 23 3026 2088 67004 3/1/2021 FRT-ORG Orange 35 26.27 17.16 24 3026 2088 67004 3/1/2021 FRT-LOA Loquat 45 25.67 17.11 25 3026 2088 67004 3/1/2021 FRT-FII Fig 50 120.52 77.51 26 3026 2088 67004 3/1/2021 FRT-JAB Jabuticaba 50 44.52 26.01 27 3027 2087 67831 3/1/2021 FRT-MAR Marionberry 10 9.52 6.11 28 3028 2086 67416 3/1/2021 FRT-ORG Orange 15 11.27 7.36 29 3028 2086 67416 3/1/2021 FRT-COU Coconut 45 108.47 69.31 30 3028 2086 67416 3/1/2021 FRT-LOA Loquat 5 2.87 1.91 31 3028 2086 67416 3/1/2021 FRT-BAN Banana 40 20.02 12.41 32 3028 2086 67416 3/1/2021 FRT-MII Miracle fruit 35 71.77 42.01 33 3028 2086 67416 3/1/2021 FRT-APO Apricot 25 70.02 44.01 34 3029 2053 66402 3/1/2021 FRT-BOR Boysenberry 15 15.02 9.31 35 3030 2063 67010 3/1/2021 FRT-APL Apple 45 76.52 49.06 36 3030 2063 67010 3/1/2021 FRT-BIT Bilberty 40 80.02 46.81 37 3030 2063 67010 3/1/2021 FRT-DRI Dragonfruit 5 8.17 4.91 38 3031 2041 66404 3/1/2021 FRT-LYE Lychee 40 80.42 50.01 39 3031 2041 66404 3/1/2021 FRT-PUE Purple mang 40 40.42 23.61 40 2022 2069 67418 3/1/2021 ERT-TAN Tamarind 2012 82 27.61 Sheet1 I O Type here to search T. File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless yo A2 fx 3021 G H 1 39 40 41 42 3031 3032 3032 3033 3033 3034 43 44 45 46 47 3035 3036 3037 3038 3039 48 49 50 3039 51 52 53 54 3039 3039 3039 3039 3039 3039 3039 3040 3040 55 56 57 58 1 B 2041 66404 2068 67418 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66406 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2087 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67732 Sheet1 23.61 27.61 29.61 24.81 23.11 51.61 54.51 27.46 33.31 24.51 6.21 19.61 39.01 7.36 4.91 24.81 10.36 12.26 62.01 11.81 16.36 43.01 15.51 35.41 17.71 69.01 D E F 3/1/2021 FRT-PUE Purple mang 3/1/2021 FRT-TAN Tamarind 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-PLT Plumcot (or 3/1/2021 FRT-SAR Salal berry 3/1/2021 FRT-BLR Blackberry 3/1/2021 FRT-CUE Cucumber 3/1/2021 FRT-CRR Cranberry 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-ORG Orange 3/2/2021 FRT-PLI Plantain 3/2/2021 FRT-DRI Dragonfruit 3/2/2021 FRT-CHR Cherry 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SUL Sugar apple 3/2/2021 FRT-UGI Ugli fruit 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-PLT Plumcot (or 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-JUR Juniper berry 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-AVD Avocado 3/2/2021 FRT-TAN Tamarind 3/2/2021 FRT-APL Apple 3/2/2021 FRT-KUA Kumquat 3/2/2021 FRT-CUE Cucumber 3/2/2021 FRT-GOR Goji berry 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-JAB Jabuticaba 3/2/2021 FRT-PEA Pear 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-RAR Raspberry 3/2/2021 FRT-POT Pomegranat 3/2/2021 FRT-LIM Lime 3/2/2021 FRT-PAY Papaya 3/2/2021 FRT-BLR Blackberry 372/2021 ERT-EEO Faina 40 40.42 20 43.82 40 50.02 20 42.02 35 39.22 40 80.02 50 91.02 45 45.47 45 56.27 50 37.52 5 10.32 20 32.62 25 62.52 15 11.27 10 7.52 40 40.42 15 16.82 25 18.77 50 105.02 20 18.82 15 25.52 50 65.02 50 25.02 30 60.02 30 30.02 50 109.52 50 85.02 15 10.67 50 91.02 45 53.12 30 52.52 5 4.47 50 91.52 5 10.02 10 11.42 15 9.77 10 9.62 5 5.32 25 50.02 un 7922 3040 59 60 61 62 3041 3041 3042 63 64 65 66 67 68 69 3043 3043 3043 3043 3044 3044 3045 3045 70 71 54.51 6.76 54.51 33.31 31.21 2.61 53.51 6.46 7.01 6.31 5.71 3.16 32.26 72 73 74 75 76 77 79 3045 3045 3046 3046 3046 3046 2046 52.01 File Home Insert Draw Page Layout Formulas Data Review i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fic 3021 G H 1 3046 77 78 25 50.02 40 79.22 45 108.02 25 16.52 3046 3046 3046 79 32.26 52.01 65.71 11.01 10.66 80 81 15 17.27 82 35 15 17.52 7.52 83 3047 3048 3048 3048 3048 3048 3048 10.86 4.66 2.46 84 5 85 40 58.41 86 25 B 2064 67732 2064 67732 2064 67732 2064 67732 2070 67522 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2043 66840 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2098 67023 2036 67333 2036 67333 2032 66414 3.77 96.02 43.77 46.02 12.52 87 88 20 25 3049 3050 10 10.12 89 90 3050 15 7.52 91 3050 14.12 15 5 92 93 10 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 5.91 45.51 50.86 49.06 94 5 95 35 96 D E F 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-MUR Mulberry 3/2/2021 FRT-PEC Peach 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-RAA Rambutan 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-PUE Purple mang 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-YUZ Yuzu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-PLM PlumPrune 3/2/2021 FRT-PAI Passionfruit 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-JAU Jambul 3/2/2021 FRT-CLR Cloudberry 3/2/2021 FRT-DAO Damson 3/2/2021 FRT-BLN Blackcurrent 3/2/2021 FRT-PHI Physalis 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-PIL Pineapple 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-JUB Jujube 3/3/2021 FRT-JAI Jackfruit 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-CRR Cranberry 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-PEA Pear 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-APL Apple 3/3/2021 FRT-CLR Cloudberry 3/3/2021 ERT-STR Strawberry 3050 3050 3050 3051 3052 3052 3053 3053 3054 3054 3054 3054 97 10 35 45 98 99 2032 66414 45 25 100 101 102 103 104 10 40 33.51 11.81 44.81 22.41 16.11 40 35 3054 3054 7.52 17.02 6.57 32.92 9.42 69.32 87.77 78.77 51.02 20.02 72.82 37.62 26.97 20.02 59.62 9.47 23.72 45.47 73.52 82.97 54.92 22.52 17.02 70.02 2402 105 40 12.41 106 40 15 38.01 5.56 10 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2063 67335 2063 67335 2022 67925 Sheet1 45 3055 3055 3055 3055 3055 3055 3055 3055 107 108 109 110 111 112 113 114 115 116 50 35 15.41 27.46 48.01 53.91 32.11 13.96 10.91 30 45 10 3056 40 3056 2057 43.61 15.61 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 3021 A G 1 115 116 117 118 119 120 121 122 123 B 2063 67335 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 2055 67432 2055 67432 2046 67026 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2088 67631 2088 67631 3056 3057 3058 3058 3059 3059 3059 3059 3060 3061 3061 3061 3061 3061 3061 3061 3061 3062 3062 3063 3063 3063 3064 3064 124 43.61 15.61 6.61 8.81 7.11 4.66 22.81 10.31 31.06 4.66 29.51 44.41 16.36 29.61 19.61 4.91 25.21 9.91 18.31 H 40 70.02 30 24.02 5 10.87 20 13.22 10 11.52 5 7.52 15 36.17 10 17.52 45 50.42 15 7.52 50 50.02 40 70.02 15 25.52 40 50.02 40 30.02 10 7.52 40 38.42 15 16.82 30 28.22 10 14.72 5 3.57 15 29.87 15 34.82 50 40.52 20 15.42 45 33.77 25 45.52 15 30.62 10 7.72 50 85.02 50 100.52 30 44.72 5 12.52 20 46.22 2038 66725 D E F 3/3/2021 FRT-CLR Cloudberry 3/3/2021 FRT-STR Strawberry 3/3/2021 FRT-DUA Durian 3/3/2021 FRT-MUR Mulberry 3/3/2021 FRT-PEC Peach 3/3/2021 FRT-YUZ Yuzu 3/3/2021 FRT-ELR Elderberry 3/3/2021 FRT-CHI Chico fruit 3/3/2021 FRT-UGI Ugli fruit 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-AVD Avocado 3/3/2021 FRT-CHY Cherimoya 3/3/2021 FRT-APL Apple 3/3/2021 FRT-GRI GrapeRaisin 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-HUR Huckleberry 3/3/2021 FRT-SAR Salal berry 3/3/2021 FRT-PAI Passionfruit 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-KUA Kumquat 3/3/2021 FRT-PEO Persimmon 3/3/2021 FRT-KII Kiwifruit 3/3/2021 FRT-SAA Salak 3/3/2021 FRT-TAL Tamarillo 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-PHI Physalis 3/4/2021 FRT-DAO Damson 3/4/2021 FRT-PIL Pineapple 3/4/2021 FRT-APL Apple 3/4/2021 FRT-LYE Lychee 3/4/2021 FRT-JUB Jujube 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-PLI Plantain 3/4/2021 FRT-BLR Blackberry 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/1/2021 ERT-COR Goi berry 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 9.61 2.26 18.46 20.56 25.01 3065 3065 10.21 22.06 28.01 20.11 4.61 54.51 3065 3065 3066 3067 3067 3067 3067 3067 3067 3068 3068 3068 3068 2069 2038 66725 2038 66725 2006 67031 2006 67031 2067 67837 2067 67837 2067 67837 2067 67837 2047 66939 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2046 67035 2046 67035 2046 67035 2046 67035 2046 67025 Sheet1 40 30 82.42 60.02 62.51 28.51 7.86 29.41 49.61 38.71 2.86 9.81 59.21 5 20 4.82 15.02 98.42 4722 40 un 154 29 61 File Home Insert Draw Page Layout Formulas Data Rev PROTECTED VIEW Be carefulfiles from the Internet can contain viruses, A2 fx 3021 G H 1 J 2.86 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 A 3068 3068 3068 3068 3068 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3070 3070 3070 3070 3071 3071 3071 3072 3072 3072 3072 3072 3072 3072 3072 B C 2046 67035 2046 67035 2046 67035 2046 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2018 67342 2018 67342 2018 67342 2018 67342 2044 67042 2044 67042 2044 67042 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 D E F 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-STR Strawberry 3/4/2021 FRT-BIT Bilberty 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-RAR Raspberry 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-SUL Sugar app! 3/4/2021 FRT-APO Apricot 3/4/2021 FRT-BAN Banana 3/4/2021 FRT-DAT Date 3/4/2021 FRT-GRI GrapeRaisi 3/4/2021 FRT-MAR Marionbern 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-DAT Date 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-SAA Salak 3/4/2021 FRT-PLM Plum Prune 3/4/2021 FRT-RAA Rambutan 3/4/2021 FRT-APL Apple 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-REN Redcurrant 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-COU Coconut 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-NAC Nance 3/4/2021 FRT-KII Kiwifruit 3/4/2021 FRT-JAI Jackfruit 3/4/2021 FRT-OLV Olive 3/4/2021 FRT-JAU Jambul 3/4/2021 FRT-BOR Boysenber 3/4/2021 FRT-TAL Tamarillo 3/4/2021 FRT-HUR Hucklebern 3/4/2021 FRT-POT Pomegran 3/4/2021 FRT-CHR Cherry 5 4.82 20 15.02 40 98.42 40 47.22 5 2.87 35 28.02 50 100 10 19.42 45 46.37 40 45.62 40 37.62 35 80.87 25 25.27 50 140 40 20.02 5 4.17 50 62.52 35 33.27 20 15.02 15 12.47 40 30.02 35 28.37 10 13.12 20 46.02 20 34.02 5 5.17 30 58.22 45 33.77 15 21.32 30 75.02 35 84.37 40 37.62 10 11.82 5 2.87 40 47.22 20 46.42 20 12.62 10 15.42 40 78.02 50 50.02 35 26.97 5 4.82 40 26.02 5 5 12.52 9.81 59.21 29.61 1.91 18.21 58.51 12.01 28.36 28.01 23.61 51.46 15.51 88.01 12.41 2.71 37.01 21.36 9.81 8.11 19.61 17.51 7.71 30.41 21.81 3.16 36.01 22.06 12.76 47.11 53.91 23.61 7.41 1.91 28.81 27.41 7.41 9.51 45.21 31.01 17.86 3.16 16.81 7.81 Sheet1