Please please i need a help with this.. thanks alot

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 ofthe screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the nal 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 salesjournal that records each sale and its related sales and cost details. This sales journal is for March 14. 2021. Use data file Lab 2-4 Dataxlsx, but open in Tableau. Software needed - Tableau - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) 0 This question will be sent to your instructor for grading. C'D rst 1 2 of 2 iii Nest > bleau Lab 2.4 i Saved Help Data: Lab 2-4 Data.xIsx. Perform the Analysis: Refer to Lab 2-4 in the text for instructions and steps for each of the lab parts. Share the Story: rt 1 of 2 Part 1: Upload Your Files Part 2: Assessment its 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 This question will be sent to your instructor for grading. w Prev 1 2 of 2 Next >File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you nee A2 X V fx 3021 A B C D E F G H J 1 Invoice # Customer # Zip Code Date of Sal SKU Description | Quantity (Pound: Sales Cost 3021 2001 67510 3/1/2021 FRT-APL Apple 15 25.52 16.36 3021 2001 67510 3/1/2021 FRT-GOR Goji berry 5 5.92 3.71 3021 2001 67510 3/1/2021 FRT-OLV Olive 35 53.92 33.26 3021 2001 67510 3/1/2021 FRT-REN Redcurrant 5 7.12 4.26 3022 2091 67621 3/1/2021 FRT-FII Fig 35 84.37 54.26 3023 2021 67511 3/1/2021 FRT-JUR Juniper berr 50 65.02 43.01 3023 2021 67511 3/1/2021 FRT-PAY Papaya 35 37.12 22.06 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 2032 7068 67418 3/1/2071 ERT-TAN Tamarind 20 12 87 27 61 Sheet1 + + Type here to search O FiFile Home Insert Draw Page Layout Formulas Data Review Vie PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless yo A2 X V fx 3021 A B C D E F G H 39 3031 2041 66404 3/1/2021 FRT-PUE Purple mang 40 40.42 23.61 40 3032 2068 67418 3/1/2021 FRT-TAN Tamarind 20 43.82 27.61 41 3032 2068 67418 3/1/2021 FRT-GRI GrapeRaisin 40 50.02 29.61 42 3033 2051 67332 3/1/2021 FRT-PLT Plumcot (or) 20 42.02 24.81 43 3033 2051 67332 3/1/2021 FRT-SAR Salal berry 35 39.22 23.11 44 3034 2077 66749 3/1/2021 FRT-BLR Blackberry 40 80.02 51.61 45 3035 2051 66713 3/1/2021 FRT-CUE Cucumber 50 91.02 54.51 46 3036 2044 67516 3/1/2021 FRT-CRR Cranberry 45 45.47 27.46 47 3037 2073 66406 3/1/2021 FRT-GRI GrapeRaisin 45 56.27 33.31 48 3038 2064 67012 3/1/2021 FRT-ORG Orange 50 37.52 24.51 49 3039 2060 67518 3/2/2021 FRT-PLI Plantain 5 10.32 6.21 50 3039 2060 67518 3/2/2021 FRT-DRI Dragonfruit 20 32.62 19.61 51 3039 2060 67518 3/2/2021 FRT-CHR Cherry 25 62.52 39.01 52 3039 2060 67518 3/2/2021 FRT-ORG Orange 15 11.27 7.36 53 3039 2060 67518 3/2/2021 FRT-ORG Orange 10 7.52 4.91 54 3039 2060 67518 3/2/2021 FRT-SUL Sugar apple 40 40.42 24.81 55 3039 2060 67518 3/2/2021 FRT-UGI Ugli fruit 15 16.82 10.36 56 3039 2060 67518 3/2/2021 FRT-ORG Orange 25 18.77 12.26 57 3039 2060 67518 3/2/2021 FRT-PLT Plumcot (or) 50 105.02 62.01 58 3040 2074 67422 3/2/2021 FRT-SOS Solanum qui 20 18.82 11.81 59 3040 2074 67422 3/2/2021 FRT-APL Apple 15 25.52 16.36 60 3040 2074 67422 3/2/2021 FRT-JUR Juniper berr 50 65.02 43.01 61 3041 2066 66408 3/2/2021 FRT-BAN Banana 50 25.02 15.51 62 3041 2066 66408 3/2/2021 FRT-BLN Blackcurren 30 60.02 35.41 63 3042 2035 67423 3/2/2021 FRT-AVD Avocado 30 30.02 17.71 64 3043 2087 67731 3/2/2021 FRT-TAN Tamarind 50 109.52 69.01 65 3043 2087 67731 3/2/2021 FRT-APL Apple 50 85.02 54.51 66 3043 2087 67731 3/2/2021 FRT-KUA Kumquat 15 10.67 6.76 67 3043 2087 67731 3/2/2021 FRT-CUE Cucumber 50 91.02 54.51 68 3044 2048 67018 3/2/2021 FRT-GOR Goji berry 45 53.12 33.31 69 3044 2048 67018 3/2/2021 FRT-CUN Currant 30 52.52 31.21 70 3045 2100 66226 3/2/2021 FRT-JAB Jabuticaba 5 4.47 2.61 71 3045 2100 66226 3/2/2021 FRT-PEA Pear 50 91.52 53.51 72 3045 2100 66226 3/2/2021 FRT-BLR Blackberry 5 10.02 6.46 73 3045 2100 66226 3/2/2021 FRT-RAR Raspberry 10 11.42 7.01 74 3046 2064 67732 3/2/2021 FRT-POT Pomegranat 15 9.77 6.31 75 3046 2064 67732 3/2/2021 FRT-LIM Lime 10 9.62 5.71 76 3046 2064 67732 3/2/2021 FRT-PAY Papaya 5 5.32 3.16 77 3046 2064 67732 3/2/2021 FRT-BLR Blackberry 25 50.02 32.26 3046 2064 67732 2/2/2021 ERT-FEO Folina 79 27 57 01 Sheet1 +File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless A2 X v fx 3021 A B C D E F G H 77 3046 2064 67732 3/2/2021 FRT-BLR Blackberry 25 50.02 32.26 78 3046 2064 67732 3/2/2021 FRT-FEO Feijoa 40 79.22 52.01 79 3046 2064 67732 3/2/2021 FRT-SOO Soursop 45 108.02 65.71 80 3046 2064 67732 3/2/2021 FRT- MUR Mulberry 25 16.52 11.01 81 3047 2070 67522 3/2/2021 FRT-PEC Peach 15 17.27 10.66 82 3048 2031 67626 3/2/2021 FRT-BAN Banana 35 17.52 10.86 83 3048 2031 67626 3/2/2021 FRT-BAN Banana 15 7.52 4.66 84 3048 2031 67626 3/2/2021 FRT-ORG Orange 5 3.77 2.46 85 3048 2031 67626 3/2/2021 FRT-SOO Soursop 40 96.02 58.41 86 3048 2031 67626 3/2/2021 FRT-CUN Currant 25 43.77 26.01 87 3048 2031 67626 3/2/2021 FRT-RAA Rambutan 20 46.02 30.41 88 3049 2043 66840 3/2/2021 FRT-BAN Banana 25 12.52 7.76 89 3050 2084 66936 3/2/2021 FRT-PUE Purple mang 10 10.12 5.91 90 3050 2084 66936 3/2/2021 FRT-BAN Banana 15 7.52 4.66 91 3050 2084 66936 3/2/2021 FRT-GUV Guava 15 14.12 8.41 92 3050 2084 66936 3/2/2021 FRT-YUZ Yuzu 5 7.52 4.66 93 3050 2084 66936 3/2/2021 FRT-APL Apple 10 10.91 94 3050 2084 66936 3/2/2021 FRT-PLM PlumPrune ( 5 6.57 3.86 95 3051 2098 67023 3/2/2021 FRT-PAI Passionfruit 35 32.92 21.36 96 3052 2036 67333 3/2/2021 FRT-SOS Solanum qu 10 9.42 5.91 97 3052 2036 67333 3/2/2021 FRT-FEO Feijoa 35 69.32 45.51 98 3053 2032 66414 3/2/2021 FRT- JAU Jambul 45 87.77 50.86 99 3053 2032 66414 3/2/2021 FRT-CLR Cloudberry 45 78.77 49.06 100 3054 2088 66842 3/2/2021 FRT-DAO Damson 25 51.02 33.51 101 3054 2088 66842 3/2/2021 FRT-BLN Blackcurren 10 20.02 11.81 102 3054 2088 66842 3/2/2021 FRT-PHI Physalis 40 72.82 44.81 103 3054 2088 66842 3/2/2021 FRT-GUV Guava 40 37.62 22.41 104 3054 2088 66842 3/2/2021 FRT-PIL Pineapple 35 26.97 16.11 105 3054 2088 66842 3/2/2021 FRT-BAN Banana 40 20.02 12.41 106 3055 2081 66014 3/2/2021 FRT-JUB Jujube 40 59.62 38.01 107 3055 2081 66014 3/3/2021 FRT-JAI Jackfruit 15 9.47 5.56 108 3055 2081 66014 3/3/2021 FRT-POL Pomelo 10 23.72 15.41 109 3055 2081 66014 3/3/2021 FRT-CRR Cranberry 45 45.47 27.46 110 3055 2081 66014 3/3/2021 FRT-NEN Nectarine 50 73.52 48.01 111 3055 2081 66014 3/3/2021 FRT-POL Pomelo 35 82.97 53.91 112 3055 2081 66014 3/3/2021 FRT-PEA Pear 30 54.92 32.11 113 3055 2081 66014 3/3/2021 FRT-BAN Banana 45 22.52 13.96 114 3056 2063 67335 3/3/2021 FRT-APL Apple 10 17.02 10.91 115 3056 2063 67335 3/3/2021 FRT-CLR Cloudberry 40 43.61 1 16 3057 On72 67835 2/2/2071 ERT-STR Strawhorry ! 20 15 61 Sheet1 +File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless A2 X v fx 3021 A B C D E F G H 15 3056 2063 67335 3/3/2021 FRT-CLR Cloudberry 40 70.02 43.61 116 3057 2023 67835 3/3/2021 FRT-STR Strawberry 30 24.02 15.61 117 3058 2046 66416 3/3/2021 FRT-DUA Durian 5 10.87 6.61 118 3058 2046 66416 3/3/2021 FRT-MUR Mulberry 20 13.22 3.81 119 3059 2055 67432 3/3/2021 FRT-PEC Peach 10 11.52 7.11 120 3059 2055 67432 3/3/2021 FRT-YUZ Yuzu 5 7.52 4.66 121 3059 2055 67432 3/3/2021 FRT-ELR Elderberry 15 36.17 22.81 122 3059 2055 67432 3/3/2021 FRT-CHI Chico fruit 10 17.52 10.31 123 3060 2046 67026 3/3/2021 FRT-UGI Ugli fruit 45 50.42 31.06 124 3061 2024 66937 3/3/2021 FRT-BAN Banana 15 7.52 4.66 125 3061 2024 66937 3/3/2021 FRT-AVD Avocado 50 50.02 29.51 126 3061 2024 66937 3/3/2021 FRT-CHY Cherimoya 40 70.02 44.41 127 3061 2024 66937 3/3/2021 FRT-APL Apple 15 25.52 16.36 128 3061 2024 66937 3/3/2021 FRT-GRI GrapeRaisin 40 50.02 29.61 129 3061 2024 66937 3/3/2021 FRT-ORG Orange 40 30.02 19.61 130 3061 2024 66937 3/3/2021 FRT-ORG Orange 10 7.52 4.91 131 3061 2024 66937 3/3/2021 FRT-HUR Huckleberry 40 38.42 25.21 132 3062 2088 67631 3/3/2021 FRT-SAR Salal berry 15 16.82 9.91 133 3062 2088 67631 3/3/2021 FRT-PAI Passionfruit 30 28.22 18.31 134 3063 2038 66725 3/3/2021 FRT-NEN Nectarine 10 14.72 9.61 135 3063 2038 66725 3/3/2021 FRT-KUA Kumquat 5 3.57 2.26 136 3063 2038 66725 3/3/2021 FRT-PEO Persimmon 15 29.87 18.46 137 3064 2006 67031 3/3/2021 FRT-KII Kiwifruit 15 34.82 20.56 138 3064 2006 67031 3/3/2021 FRT-SAA Salak 50 40.52 25.01 139 3065 2067 67837 3/3/2021 FRT-TAL Tamarillo 20 15.42 10.21 140 3065 2067 67837 3/3/2021 FRT-ORG Orange 45 33.77 22.06 141 3065 2067 67837 3/3/2021 FRT-PHI Physalis 25 45.52 28.01 142 3065 2067 67837 3/4/2021 FRT-DAO Damson 15 30.62 20.11 143 3066 2047 66939 3/4/2021 FRT-PIL Pineapple 10 7.72 4.61 144 3067 2072 66736 3/4/2021 FRT-APL Apple 50 85.02 54.51 145 3067 2072 66736 3/4/2021 FRT-LYE Lychee 50 100.52 62.51 146 3067 2072 66736 3/4/2021 FRT-JUB Jujube 30 44.72 28.51 147 3067 2072 66736 3/4/2021 FRT-STI Star fruit 5 12.52 7.86 148 3067 2072 66736 3/4/2021 FRT-MAG Mango 20 46.22 29.41 149 3067 2072 66736 3/4/2021 FRT-PLI Plantain 40 82.42 49.61 150 3068 2046 67035 3/4/2021 FRT-BLR Blackberry 30 60.02 38.71 151 3068 2046 67035 3/4/2021 FRT-LIM Lime 5 4.82 2.86 152 3068 2046 67035 3/4/2021 FRT-ORG Orange 20 15.02 9.81 153 3068 2046 67035 3/4/2021 FRT-LEO Lemon 40 98.42 59.21 154 2068 2046 67035 2/4/2021 ERT-GOB Goii horry An 47 27 29 61 Sheet1 +File Home Insert Draw Page Layout Formulas Data Rev i PROTECTED VIEW Be careful-files from the Internet can contain viruses A2 X V fx 3021 A B C D E F G H 151 3068 2046 67035 3/4/2021 FRT-LIM Lime 5 4.82 2.86 152 3068 2046 67035 3/4/2021 FRT-ORG Orange 20 15.02 9.81 153 3068 2046 67035 3/4/2021 FRT-LEO Lemon 40 98.42 59.21 154 3068 2046 67035 3/4/2021 FRT-GOR Goji berry 40 47.22 29.61 155 3068 2046 67035 3/4/2021 FRT-LOA Loquat 5 2.87 1.91 156 3069 2047 67838 3/4/2021 FRT-STR Strawberry 35 28.02 18.21 157 3069 2047 67838 3/4/2021 FRT-BIT Bilberty 50 100 58.51 158 3069 2047 67838 3/4/2021 FRT-MEC Melon 10 19.42 12.01 159 3069 2047 67838 3/4/2021 FRT-QUC Quince 45 46.37 28.36 160 3069 2047 67838 3/4/2021 FRT-RAR Raspberry 40 45.62 28.01 161 3069 2047 67838 3/4/2021 FRT-HOR Honeyberry 40 37.62 23.61 162 3069 2047 67838 3/4/2021 FRT-MAG Mango 80.87 51.46 163 3069 2047 67838 3/4/2021 FRT-SUL Sugar appl 25 25.27 15.51 164 3069 2047 67838 3/4/2021 FRT-APO Apricot 50 140 88.01 165 3069 2047 67838 3/4/2021 FRT-BAN Banana 20.02 12.41 166 3069 2047 67838 3/4/2021 FRT-DAT Date 5 4.17 2.71 167 3069 2047 67838 3/4/2021 FRT-GRI GrapeRaisi 50 62.52 37.01 168 3069 2047 67838 3/4/2021 FRT-MAR Marionbern 35 33.27 21.36 169 3069 2047 67838 3/4/2021 FRT-ORG Orange 20 15.02 9.81 170 3069 2047 67838 3/4/2021 FRT-DAT Date 15 12.47 8.11 171 3069 2047 67838 3/4/2021 FRT-ORG Orange 40 30.02 19.61 172 3069 2047 67838 3/4/2021 FRT-SAA Salak 35 28.37 17.51 173 3069 2047 67838 3/4/2021 FRT-PLM PlumPrune 10 13.12 7.71 174 3069 2047 67838 3/4/2021 FRT-RAA Rambutan 20 46.02 30.41 175 3069 2047 67838 3/4/2021 FRT-APL Apple 20 34.02 21.81 176 3069 2047 67838 3/4/2021 FRT-QUC Quince 5 5.17 3.16 177 3069 2047 67838 3/4/2021 FRT-MEC Melon 30 58.22 36.01 178 3069 2047 67838 3/4/2021 FRT-ORG Orange 45 33.77 22.06 179 3069 2047 67838 3/4/2021 FRT-REN Redcurrant 15 21.32 12.76 180 3070 2018 67342 3/4/2021 FRT-STI Star fruit 30 75.02 47.11 181 3070 2018 67342 3/4/2021 FRT-COU Coconut 35 84.37 53.91 182 3070 2018 67342 3/4/2021 FRT-HOR Honeyberr 40 37.62 23.61 183 3070 2018 67342 3/4/2021 FRT-GOR Goji berry 10 11.82 7.41 184 3071 2044 67042 3/4/2021 FRT-LOA Loquat 5 2.87 1.91 185 3071 2044 67042 3/4/2021 FRT-NAC Nance 40 47.22 28.81 186 3071 2044 67042 3/4/2021 FRT-KII Kiwifruit 20 46.42 27.41 187 3072 2100 67344 3/4/2021 FRT-JAI Jackfruit 20 12.62 7.41 188 3072 2100 67344 3/4/2021 FRT-OLV Olive 10 15.42 9.51 189 3072 2100 67344 3/4/2021 FRT-JAU Jambul 40 78.02 45.21 190 3072 2100 67344 3/4/2021 FRT-BOR Boysenben 50 50.02 31.01 191 3072 2100 67344 3/4/2021 FRT-TAL Tamarillo 35 26.97 17.86 192 3072 2100 67344 3/4/2021 FRT-HUR Huckleberry 5 4.82 3.16 193 3072 2100 67344 3/4/2021 FRT-POT Pomegran 40 26.02 16.81 194 3072 2100 67344 3/4/2021 FRT-CHR Cherry 5 12.52 7.81 Sheet1 +Tableau Lab 2.4 i Saved 2 Required information Part 2 of 2 3. Which "pill" do you have on the Marks card? O Customer # points O Sum(Gross Margin) Skipped O Count(Customer #) O Gross Margin eBook 4. What is the gross margin of customer 2070? O 6.6 Print O 11.6 O 44.9 References O 107.4 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.52 Part 20f2 5 points Skipped eBook it! Print [El References anon: 1.: II: gun J. Part 1: Upload Your Files Part 2: Assessment Required: 1. Which customer number is the least protable with $4.80 gross margin? 0 2024 O 2051 O 2031 O 2043 2. Which \"pill\" do you have on the Rows shelf? 0 Gross Margin O Counthustomer 21') 0 Customer# 0 Sum(Gross Margin) 3. Which \"pill" do you have on the Marks card? 0 Customer# 0 Sum(Gross Margin} O Counthustomer 21') 0 Gross Margin