A B D K L M N O Month Year Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 16 140 22 100 13 160 7 16 240 3 11 400 10 16 160 E F G H Customer Name Product Descr 2018 Sara 3109EA243 Face Puff 2018 Horeka 3109UMY79 Scrub 2016 Volpi 3109UMY77 Hair Spa 2020 zgr 3109UMY45 Mac Brush 2019 Adria 3109EA243 Organic 2017 Dou 3109UMY54 Wax 2015 Kamel 3109EA518 Pomade 2020 Grup 3109EA915 Lotion 2017 Hasel 3109UMY12 Wax 2017 Hamann hellm 3109EA119 Volumizer 2020 istanbul 3109EA376 Loreal Series 2015 Ambiance 3109EA329 Biotique Facial Kit 2015 Roni 3109UMY74 Leave in Conditioner 2020 Ozan 3109UMY53 Curl Enhancing 2015 Brosit 3109EA915 Unscented 2018 Evim 3109EA516 Hair Straightner 2019 Ycel 3109UMY55 Bleach Cream 2017 Altin 3109UMY38 Lacto Oil Balance 2015 Hat 3109UMY53 Hair Wax 2019 Dion 3109UMY55 Curl Enhancing 2018 Hisar 3109EA826 Nature Pack 2018 Horeka 3109UMY68 Water Spray 2018 Universal 3109UMY2 Loreal Series 2018 Gzel 3109EA913 Root Pump 1 1 5 240 8 260 1 5 6 400 2 2 280 5 2 100 6 5 100 5 5 180 26 340 Boca 19 200 9 5 120 6 3 260 13 360 1 13 120 Windows'u Etkinletir Windowslettintestine A J K L M 25 26 27 28 29 30 31 32 33 34 35 36 37 B C D E F G H 1 1 13 120 2018 Gzel 3109EA913 Root Pump 10 14 120 2019 Keyf 3109EA826 Mac Brush 11 11 140 2017 CCK 3109EA617 Conditioning Mask 2 28 160 2020 Yeni 3109EA562 Face Pack 6 28 280 2015 Inter 3109UMY68 Scrub 3 1 320 2020 Wein 3109UMY59 Color Extending 10 20 400 2017 Linea 3109UMY49 Organic 4 9 9 280 2020 Sahne 3109EA521 Serum 5 3 140 2015 Gndodu 3109UMY49 Mousse 12 23 360 2017 Dou 3109EA956 Volumizer 5 17 360 2018 Gaziantepli 3109UMY54 Scrub 9 27 120 2017 LOTS 3109EA765 Gatsby Wax 11 7 380 2015 Tepe 3109EA562 Nature Pack 1 280 2017 Horeka 3109UMY38 Comb 12 24 320 2017 Wein 3109UMY60 Organic 4 23 280 2016 Altek 3109EA243 Facial Pack 10 14 380 2017 Akbulut 3109EA243 Scrub 6 8 360 2015 Hilal 3109UMY79 Massage Cream 3 16 400 2020 Ataizi 3109EA663 Room Freshener 11 23 320 2016 Tmlas 3109EA119 Leave in Conditioner 12 23 160 2020 CCK 3109UMY79 Feature 12 20 300 2020 Cennet 3109UMY55 Paraben Free 5 5 4 400 2019 Gallery 3109UMY4 Facial Pack 3 10 120 2016 Vetrina 3109EA765 Conditioning Mask 11 16 360 2019 Unotek 3109EA139 Mac Brush Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories 38 4 39 40 41 42 43 44 45 46 47 48 49 Windows Windows Regions KI MAIN Products Customers IVIOIILIT A B D E 1 J K L M 49 11 16 360 2 360 50 51 2 3 9 16 140 16 140 12 20 400 52 53 54 55 4 26 280 400 4 3 56 6 26 400 F G H 3109EA139 Mac Brush 3109UMY74 Hair Comb 3109EA329 Water Spray 3109EA956 Lotus Herbal 3109UMY59 Nova Straightner 3109EA444 Paraben Free 3109EA518 Texturizer 3109UMY68 Shahnaz Protein Mask 3109UMY69 Root Pump 3109UMY59 Hair Wax 3109UMY54 Oil 3109UMY45 Gel 3109UMY64 Comb 3109UMY52 Unscented 3109UMY49 Hair Wax 3109UMY23 Hair Wax 3109UMY24 Leave in Conditioner 57 10 12 2019 Unotek 2019 Hakzerler 2017 Zivella 2016 Recep 2015 Yona 2017 Mrs 2017 Armine 2015 Horeka 2018 Iglotek 2017 Art 2018 Akaln 2019 Selim 2016 Asil 2020 Mustafa 2019 ilke 2019 La 2019 Fze 100 8 120 58 59 1 10 9 2 100 60 2 320 61 11 23 100 3 22 320 62 63 14 260 2 5 64 18 140 65 10 23 360 66 67 68 69 70 71 72 73 KI Window Windows Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers A B 1 J K L M Month Day 2 Quantity 15 25 17 6 8 1 9 27 6 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMN ADDING A NEW CALCULATED COLUMNE ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLU THOUGH 8 3 1 13 8 6 9 4 28 11 24 2020 Fuga 9 8 1 5 D E F G H Year Customer Name Product Descr 100 2015 Saltolu 3109EA554 Face Capsule 340 2019 Messt 3109EA980 Nature Pack 120 2017 Ecem 3109UMY19 Alcohol Free 300 2019 Vankim 3109UMY55 Biotique Ayurveda 180 2017 Atila 3109EA770 Paraben Free 400 2018 Can 3109UMY71 Hair Wax 260 2016 Elize 3109UMY33 Nova Straightner 380 2020 Evim 3109EA312 Bleach Cream 240 2017 Ataizi 3109EA911 Massage Cream 360 2020 Tpy 3109EA956 Nova Straightner 240 3109EA966 Color Extending 200 2018 Gencay 3109UMY3 Hair Straightner 180 2017 ibir 3109EA444 Hair Color 360 2015 Line 3109EA437 Anti Frizz 140 2018 Tramer 3109EA424 Gel 280 2018 Wein 3109UMY71 Color Extending 200 2016 Adria 3109EA842 Clay 400 2016 Altnta 3109EA312 Hair Straightner 260 2016 Elano 3109EA163 Face Puff 340 2018 stikbal 3109EA554 Curling Tong 120 2015 Akmerta 3109EA424 Mousse 320 2018 Macitler 3109UMY26 Color Extending 200 2018 Ekto 3109EA872 Scrub 320 2019 Davenza 3109EA 749 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 17 9 8 1 28 12 5 1 29 9 1 12 3 29 4 6 8 2 10 3 10 12 25 Windows'u Windows'uneiki Products Customers Regions MAIN Formula and Macro Questions Price Categories azu A1 for Month B C D H 1 6 7 28 5 29 12 1 9 12 9 1 140 280 200 400 260 340 120 320 3 29 1 22 4 6 2 8 E 2018 Tramer 2018 Wein 2016 Adria 2016 Altnta 2016 Elano 2018 istikbal 2015 Akmerta 2018 Macitler 2018 Ekto 2019 Davenza 2017 A1 2020 Halaman 2017 Linea 2019 Visys 2015 Esste F G 3109EA424 Gel 3109UMY71 Color Extending 3109EA842 Clay 3109EA312 Hair Straightner 3109EA163 Face Puff 3109EA554 Curling Tong 3109EA424 Mousse 3109UMY26 Color Extending 3109EA872 Scrub 3109EA 749 Wahl Trimmer 3109EA813 Loreal Series 3109UMY36 Lacto Oil Balance 3109UMY36 Bleach Cream 3109EA437 Hair Wax 3109UMY1 Bleach Cream 10 3 10 200 23 4 5 26 27 12 25 320 7 21 360 7 12 320 00 10 0 0 0 0 0 400 19 1 25 260 12 26 220 1 2 3 24 5 6 7 8 59 20 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Month Quantity 21 Day 2 7 1 8 20 5 16 10 5 DO NOT MAKE ANY (CHANGING THE ORDER ADDING A NEW CALCULA ON THIS P YOU CAN CHANGE THE WID THOUG 9 21 8 11 8 19 4 6 10 8 12 4 1 30 Year Customer Name Product Descr 280 2020 ABC 3109EA479 Gel 160 2016 Horoz 3109UMY35 Gel 220 2016 Akmer 3109EA854 Hair Spray 400 2016 Grup 3109UMY76 Leave in Conditioner 220 2018 Volpi 3109EA445 Wahl Trimmer 140 2019 zgr 3109EA760 Loreal Series 320 2018 Dion 3109UMY35 Face Wash 240 2018 Trusa 3109UMY53 Water Spray 400 2018 Gkeler 3109EA864 Biotique Ayurveda 180 2020 Uur 3109EA423 Scrub 300 2015 Elize 3109UMY62 Makeup Brush 240 2016 New 3109EA549 Pomade 300 2016 Zebrano 3109UMY9 Root Pump 360 2019 Engince 3109UMY77 Root Pump 340 2015 imeks 3109UMY39 Bleach Cream 240 2019 Bedesten 3109EA333 Oil 160 2019 Mzf 3109EA955 Gatsby Wax 320 2018 Gktun 3109UMY53 Face Wash 240 2018 Art 3109UMY13 Loreal Series 300 2020 FM 3109EA760 Comb 260 2017 Cennet 3109EA854 Mousse 160 2017 Horoz 3109EA167 Gatsby Wax 360 2018 Vemsan 3109EA41 Hair Wax 180 2018 Zebrano 3109EA857 Curling Tong Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 22 11 26 11 29 1 8 1 30 12 20 9 14 12 14 2 27 5 4 28 11 6 13 Formula and Macro Questions Price Categories Products MAIN azir Customer 6 13 11 14 9 18 8 8 11 26 12 12 7 10 7 17 11 1 8 20 2 13 12 12 10 13 180 2018 Zebrano 3109EA857 Curling Tong 240 2015 Aydntepe 3109EA864 Mac Brush 380 2020 Doa 3109UMY2 Face Pack 180 2016 Mustafa 3109EA76 Clay 220 2019 Tmlas 3109EA459 Nova Straightner 320 2016 Adigzeller 3109EA854 Biotique Ayurveda 400 2019 Gzde 3109EA969 Curling Tong 380 2015 Akuapa 3109EA728 Water Spray 140 2016 Ozan 3109UMY68 Lotion 400 2020 Karahan 3109EA543 Gel 160 2015 Davenza 3109EA445 Heat Protectant 180 2015 Kadir 3109UMY68 Facial Pack 400 2016 Gkeler 3109EA115 Hair Spray 280 2015 Sara 3109EA938 Makeup Brush 220 2018 Asilzade 3109UMY62 Root Pump 120 2018 Keyf 3109EA851 Face Pack 320 2016 Gold 3109UMY76 Loreal Series 360 2015 znil 3109EA445 Feature 400 2018 anze 3109UMY76 Hair Color 240 2019 an 3109EA857 Comb 340 2017 imeks 3109EA173 Unscented 300 2017 Akvet 3109EA173 Mac Brush 280 2019 Horeka 3109UMY62 Blossom Face Wash 280 2020 Horeka 3109EA479 Face Puff 320 2020 Gallery 3109EA41 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 13 3 5 11 30 18 7 8 17 9 9 12 9 11 10 4 11 12 21 3 26 7 21 Wing Windo Region MAIN Formula and Macro Questions Price Categories Products Customers 11 30 120 7 18 320 8 17 360 9 9 400 12 9 240 11 10 340 4 11 300 12 21 280 2018 Keyf 2016 Gold 2015 znil 2018 anze 2019 an 2017 imeks 2017 Akvet 2019 Horeka 2020 Horeka 2020 Gallery 2018 Aker 2017 Atila 2020 Merve 2015 Zevk 2015 Baby 3109EA851 Face Pack 3109UMY76 Loreal Series 3109EA445 Feature 3109UMY76 Hair Color 3109EA857 Comb 3109EA173 Unscented 3109EA173 Mac Brush 3109UMY62 Blossom Face Wash 3109EA479 Face Puff 3109EA41 Wahl Trimmer 3109UMY62 Hair Comb 3109UMY63 Unscented 3109UMY8 Nova Straightner 3109UMY21 Texturizer 3109EA760 Nova Straightner 3 26 280 7 21 320 6 22 200 7 24 20 5 11 9 240 320 200 320 30 27 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Custom Hizalama Sayi Stiller Hcrel E F G H 1 J K L M N o Pano Yaz Tipi A1 for Price A B D 1 Price 2 Lower Bound Upper Bound Category 3 0,00 17,99 Basic 4 18,00 59,99 Premium 5 60,00 140,00 Deluxe 6 7 8 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 9 10 11 12 13 14 15 16 17 18 19 20 21 E F G H 1 K L D Sales Price 57,89 53,70 39,83 20,91 64,78 56,19 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 10,00 A Product ID 2 3109UMY49 3109UMY23 3109EA39 3109EA476 3109UMY56 3109UMY2 3109EA677 3109UMY33 0 3109EA964 1 3109EA33 2 3109EA835 3 3109UMY52 4 3109EA538 5 3109UMY73 6 3109EA539 7 3109EA347 8 3109UMY21 9 3109UMY15 LO 3109EA329 1 3109UMY44 2 3109EA854 3 3109EA545 4 3109UMY8 5 3109UMY79 MAIN B Product Name Alcohol Free Anti Frizz Biotique Ayurveda Biotique Facial Kit Bleach Cream Blossom Face Wash Clay Color Extending Comb Conditioning Mask Curl Enhancing Curling Tong Dry Shampoo Face Capsule Face Pack Face Puff Face Wash Facial Pack Feature Foam Gatsby Wax Gel Hair Caps Hair Color Formula and Macro Questions c Product Type Bulk Private Label Private Label Bulk Bulk Bulk Bulk Packaged Private Label Packaged Packaged Bulk Private Label Packaged Private Label Packaged Packaged Private Label Packaged Bulk Bulk Bulk Private Label Bulk Data Visualization 6,78 28,27 9,66 44,33 62,44 49,30 65,43 62,78 69,16 50,02 13,69 52,78 22,64 53,41 32,97 52,98 7,34 Branch Istanbul Windo Windows Customers Regions Branch Ankara Branch Izmir Price Categories Products Hazr D E F G H 1 J L A1 fx Product ID A B C 1 Product ID Product Name Product Type 23 3109EA545 Gel Bulk 24 3109UMY8 Hair Caps Private Label 25 3109UMY79 Hair Color Bulk 26 3109UMY6 Hair Comb Packaged 27 3109EA272 Hair Gel Packaged 28 3109EA 31 Hair Spa Bulk 29 3109UMY13 Hair Spray Private Label 30 3109UMY80 Hair Straightner Packaged 31 3109EA560 Hair Wax Bulk 32 3109UMY66 Heat Protectant Private Label 33 3109EA542 Lacto Oil Balance Private Label 34 3109UMY63 Leave in Conditioner Private Label 35 3109UMY68 Loreal Series Private Label 36 3109UMY65 Lotion Private Label 37 3109EA 34 Lotus Herbal Private Label 38 3109EA667 Mac Brush Private Label 39 3109EA 743 Makeup Brush Bulk 40 3109UMY51 Massage Cream Private Label 41 3109EA524 Mousse Packaged 42 3109EA553 Nature Pack Packaged 43 3109UMY74 Nova Straightner Private Label 44 3109EA918 Oil Private Label 45 3109UMY57 Organic Private Label 46 3109UMY19 Paraben Free Bulk MAIN Formula and Macro Questions Formula and Macro Questions Data Visualization Hazr Sales Price 32,97 52,98 7,34 47,91 59,57 34,57 55,55 64,49 48,43 51,65 28,08 33,40 49,56 35,49 60,57 39,28 13,90 62,83 21,25 19,02 24,89 11,01 24,52 60,01 Wind Windo Region Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers AL roduct ID D E F G H 1 K A 1 Product ID 41 3109EA524 42 3109EA553 43 3109UMY74 44 3109EA918 45 3109UMY57 46 3109UMY19 47 3109EA228 48 3109EA269 49 3109UMY59 50 3109EA625 51 3109EA326 52 3109UMY16 53 3109EA555 54 3109UMY71 55 3109UMY62 56 3109UMY70 57 3109UMY17 58 3109EA536 59 3109EA911 60 3109UMY37 B Product Name Mousse Nature Pack Nova Straightner Oil Organic Paraben Free Pomade Room Freshener Root Pump Scissor Scrub Serum Shahnaz Protein Mask Skin Toner Texturizer Trimmer Unscented Volumizer Wahl Trimmer Water Spray Wax Product Type Packaged Packaged Private Label Private Label Private Label Bulk Bulk Private Label Private Label Bulk Private Label Private Label Bulk Bulk Packaged Packaged Bulk Bulk Private Label Packaged Packaged Sales Price 21,25 19,02 24,89 11,01 24,52 60,01 12,31 6,86 39,00 14,79 26,20 43,27 37,50 39,07 16,86 20,27 41,74 11,05 68,42 29,39 58,86 61 3109EA612 62 63 Wi 64 K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr AT D E F G H 1 K B Region ID 2 3 5 5 5 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 1 5 F Customer Customer Group DA Depot DC EG IA DC DC IA IA WH DA WH Depot AK IA Depot IA DC Depot DA KA Depot Depot EG Depot MA EG DC 5 2 A 1 Customer 2 A1 3 Abba 4 ABC 5 Abr 6 Acar 7 Aceka 8 Active 9 Ada 10 Adallar 11 Adem 12 Adigzeller 13 Adria 14 Ada 15 Airpak 16 AK 17 Akabe 18 Akaln 19 Akar 20 Akay 21 Akbulut 22 Akdeniz 23 Akdin 24 Aker 25 Akif 6 3 3 7 3 7 WH MA 3 3 2 EG WH DA WH 3 DC EG 7 WH MA 7 DC MA 6 KA Depot 2 Depot DA 4 GA DC 5 Depot IA Formula and Macro Questions W Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Tapisi K 7 A a Birletir ve Ortala 600 CKIE 7 Y Biim Boyacs Pano A1 IdUIU afak nucre Biimlendirme Bicimlendir Stilleri Stiller Hizalama Sayi Hcreler Yaz Tipi 1 for Customer A B D E F G H 1 J J K L Region ID 2 4 5 5 5 2 5 7 Customer Group Depot DA GA DC Depot IA IA DC IA WH DC DA IA DC MA DC EG Depot DA WH DC MA Depot IA DC KA GA Depot EG DC IA WH WH MA 3 2 7 1 Customer 23 Akdin 24 Aker 25 Akif 26 Aki 27 Akkurt 28 Akmer 29 Akmertas 30 Akport 31 Aksa 32 Aksel 33 Aktiford 34 Akturan 35 Akuapa 36 Akvet 37 Akyol 38 Akyrekler 39 Alfa 40 Alg 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen KI MAIN Hazr 5 6 4 3 5 7 6 KA WH 3 EG WH 5 IA Depot 6 DC KA 6 DC KA 3 DC EG 3 EG Depot Formula and Macro Questions Windo Window Customers Regions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 D E F G H 1 K L I Region ID 3 5 6 A 1 Customer 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen 47 Alpplast 48 Altek 49 Alternatif 50 Altin 51 Altinel 52 Altnta 53 Always 54 Ambiance 55 Ankamar 56 Anr 6 3 3 5 1 for Customer Customer Group EG WH IA Depot DC KA DC KA DC EG EG Depot IA Depot DC AK DC KA MA WH WH KA IA Depot MA WH 6 7 6 5 7 GA DC 4 2 3 6 6 6 57 Ant 58 Antik 59 Ardini 60 Ari 61 Armine 62 Art 63 Artem 64 AS DA DC EG Depot DC KA KA WH KA WH DC EG WH MA DA DC WHIA WH MA 3 7 2 5 7 Windows Windowsure Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products 7 5 7 5 1 1 6 2 4 7 1 64 AS 65 Asil 66 Asilzade 67 Aslanlar 68 Asya 69 Ataizi 70 Atila 71 Atlas 72 Atlyem 73 Ats 74 Autoprotect 75 Aydntepe 76 Baby 77 Bari 78 Bedesten 79 Bellona 80 Berr 81 Berrak 82 Beta 83 Beys 84 Bosart 85 BRN 86 Buka 87 Brosit WH MA Depot IA Depot MA IA DC AK DC AK DC WH KA Depot DA GA Depot DC MA AK DC AK Depot DC DA Depot AK WH EG GA Depot WH KA Depot IA DC DA EG DC Depot IA IA DC 1 2 1 3 4 6 5 2 3 5 5 5 WHIA 4 Depot GA Windows'u Windows uretki Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr 85 BRN 5 86 Buka 5 87 Brosit 4 7 4 5 IA DC WHIA Depot GA MA Depot Depot GA IA Depot IA DC WH EG Depot AK DC KA MA Depot MA DC 5 3 1 6 7 7 4 WH GA 88 By 89 Can 90 CCK 91 Cennet 92 Cihangir 93 Classi 94 Comfort 95 Country 96 Cyk 97 an 98 alkan 99 etmen 100 iek 101 imen 102 Doruk 103 Davenza 104 Deka 105 Detay 106 Dion 107 Dizayn 108 Doa 7 WH MA 5 6 7 6 7 IA DC KA Depot MA WH DC KA Depot MA GA DC DC KA Depot KA AK DC WHAK 4 6 6 1 Wind 1 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Region Hazr Pano Yaz Tipi Hizalama 15 Sayi Stiller Hcreler A1 for Customer B D E G H J K L Region ID 6 1 1 2 5 4 7 6 4 5 7 A 1 Customer 106 Dion 107 Dizayn 108 Doa 109 Dota 110 Dou 111 Duayen 112 Ecem 113 EFFE 114 Ekto 115 Elano 116 Elips 117 Elize 118 Elve 119 Engince 120 Enne 121 Erbil 122 ESEREV 123 Esste 124 Evim 125 Flash 126 FM 127 Forml 128 Fuga 129 Fze C Customer Group Depot KA AK DC WHAK DA Depot IA DC WH GA DC MA KA Depot Depot GA IA DC Depot MA GA DC KA DC GA WH DC EG DA Depot IA WH EG DC MA DC Depot MA Depot EG KA DC DA DC MA WH 4 6 4 3 2 5 3 3 7 7 3 6 2 7 Windov Windows Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Region ID Customer Group 6 KA DC 2 DA DC 7 MA WH 5 3 IA WH EG DC DC EG 3 2 DA DC 4 GA WH WHAK 1 AK DC 1 5 1 1 Customer 127 Forml 128 Fuga 129 Fze 130 Gala 131 Gallery 132 Gaziantepli 133 Gencay 134 Genkan 135 Geomekanik 136 Get 137 Giri 138 Gisan 139 Gmaks 140 Gold 141 Gkeler 142 Gktun 143 Gral 144 Gzde 145 Grb 146 Grup 147 Gler 148 Gleryz 149 Glah 150 Gnaydnlar KN MAIN Hazr 2 DCIA AK Depot DC DA DA WH DC EG 2 3 5 IA DC Depot IA 5 6 WH KA 6 DC KA 2 7 7 4 WH DA MA Depot Depot MA GA DC DA DC 2 Window Windows Customers Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer D E F G H K L 1 Customer Region ID 148 Gleryz 7 149 Glah 4 150 Gnaydinlar 2 151 Gndodu 4 152 Gnhanlar 6 153 Grlek 1 154 Grman 7 155 Grah 3 156 Gzel 6 157 Haidi 7 158 Hakan 7 159 Hakk 3 160 Hakmet 3 161 Hakzerler 1 162 Halaman 4 163 Hamann hellmann 6 164 Harman 2 165 Harmanc 2 166 Has 5 167 Hasel 1 168 Hat 2 169 Hellmann 7 170 Hevin 3 171 Hilal 5 C Customer Group Depot MA GA DC DA DC DC GA Depot KA AK Depot MA WH Depot EG DC KA MA Depot Depot MA EG WH Depot EG AK DC WH GA KA Depot WH DA DA DC IA Depot Depot AK WH DA WH MA EG WH IA WH Wind Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Regio A D E F G H M B Region ID 7 3 1 Customer 169 Hellmann 170 Hevin 171 Hilal 172 Hisar 173 Hmk 174 Horeka 5 7 4 Customer Group WH MA EG WH IA WH MA Depot DC GA MA DC 7 3 WH EG 6 Depot KA IA WH 5 2 175 Horoz 176 Hseyin 177 Ingbank 178 Irmak 179 Iglotek 180 ihlas 181 ikizler 182 ilke 183 imeks 4 DA WH GA DC DA WH WH MA 2 7 3 3 184 Img 6 3 2 185 inan 186 inan 187 inci 188 inter 189 Interrior 190 stanbul 191 istikbal 192 ibir 1 2 3 2 EG WH EG Depot WH KA EG Depot Depot DA AK DC DA DC Depot EG DC DA AK Depot WH KA 1 6 Windows'u B Windows u etkin Customers Regions K4 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr do kes Calibri 11 AN Metni kaydir Genel 1 Yaptr Birletir ve Ortala Ekle Sil 4,0 ,00 ,00 5,0 Biim Ea Kopyala Biim Boyacs Pano A1 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Hizalama Say Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 2 1 6 7 4 3 1 1 5 4 5 1 Customer 190 stanbul 191 stikbal 192 ibir 193 Just 194 Kadir 195 Kadri 196 Kalsan 197 Kalyon 198 Kamel 199 Ka met 200 Kapars 201 Kar 202 Karagn 203 Karahan 204 Karakter 205 Karat 206 Kardem 207 Kargili 208 Kavas 209 Kelebek 210 Keops 211 keyf 212 Kilim 213 Koala 1 Customer Group DC DA AK Depot WH KA Depot MA Depot GA EG WH AK Depot AK DC IA WH GA DC IA Depot AK WH Depot DA WH DA GA WH DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK 2 2 4 7 5 3 6 1 6 1 6 1 Windows Windows'un Customers Regions K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Calibri A A VY E' Metni kaydir Genel EH FH Yaptr T Birletir ve Ortala , 0,00 ,00,0 Ekle Sil Y Y Ea Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Yaz Tipi Hizalama Sayi Hcr for Customer D E F G H 1 J K B Region ID 7 5 3 6 1 A 1 Customer 205 Karat 206 Kardem 207 Kargile 208 Kavas 209 Kelebek 210 Keops 211 Keyf 212 Kilim 213 Koala 214 Koray 215 Kozza 216 Kukla 6 1 6 1 1 6 Customer Group DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK AK DC WH KA EG WH Depot IA WH EG DC DA DC IA DC KA DC MA DC AK DC EG AK Depot DC DA WHAK 3 5 217 La 218 Lazzoni 3 219 Lenova 2 5 6 7 1 3 220 Leonart 221 Line 222 Linea 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge KI MAIN Hazr 1 2 1 4 4 WH GA Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Red Pano 15 Hizalama 5 Sayi Stiller Hcreler A1 D E F H 1 J L M 1 Customer 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge 229 Lutra Yaz Tipi for Customer B Region ID Customer Group 1 DC AK 3 DC EG 1 AK Depot 2 DC DA 1 WHAK 4 WH GA 2 DA DC 1 Depot AK 5 IA WH 1 AK Depot 3 EG Depot 3 Depot EG 2 DA DC 3 EG WH 7 Depot MA 4 Depot GA 2 WH DA 230 Luxxa 231 Macitler 232 Marka 233 Mass 234 Maxx 235 Maya 236 Mazzini 237 MD 238 Merve 239 Mesa 4 GA DC 3 2 240 Messt 241 Metropool 242 MG 243 Millennium 244 Mirage 245 Monalisa 246 Montel 3 DC EG DC DA DC EG KA Depot DCIA 6 5 4 4 GA WH Windows'u Windows'unetki Customers Regions MAIN Hazr Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir Fat Birlestir ve Ortala 7 Biim Boyacisi 4,000 ,00 ,0 Ekle Koullu Tablo Olarak Hucre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Hizalama Sayi Hu Yaz Tipi fr Customer A1 A E F G H 1 J J K 1 Customer 244 Mirage 245 Monalisa 246 Montel 247 Mrs 248 Mustafa 249 Muzaffer 250 Mzf 251 NDesign 252 Neptun 253 Nero 254 Neva 255 Neveda 256 New 257 Newjoy 258 Nil 259 Nisa 260 Nurelik 261 Nans 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan B D Region ID Customer Group 6 KA Depot 5 DC IA 4 GA WH 4 GA DC 4 DC GA 1 AK DC 1 AK WH 6 KA Depot 7 MA DC 3 EG DC 2 DC DA 3 EG WH 6 KA Depot 3 Depot EG 5 IA WH 5 WHIA 7 MA WH 6 WH KA 5 IA DC 1 DC AK 7 Depot MA 1 DC AK 4 GA DC 3 EG Depot Formula and Macro Questions Data Visualization w wi Customers RO MAIN Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Pano Yaz Tipi Hizalama Sayi Stiller H A1 for Customer A B D E F G H 1 K Region ID 5 1 7 1 4 3 Customer Group IA DC DC AK Depot MA DC AK GA DC EG Depot GA WH DA Depot MA Depot EG DC 4 2 7 3 5 IA DC 5 1 Customer 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan 268 z 269 zgr 270 znil 271 ztrkler 272 Polatlar 273 Rada 274 Ranseyman 275 Ravhome 276 Ray 277 Recep 278 Reform 279 Rengarenk 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara MAIN Hazr 1 6 5 4 2 1 IA Depot AK WH KA DC IA DC WH GA WH DA AK WH WH DA GA WH IA DC EG DC MA WH Depot AK 2 4 5 3 7 1 Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Re Yaptr Birletir ve Ortala CD E Kopyala Biim Boyacisi Pano 15 4,0,00 60 ,0 Ekle Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Hizalama Sayi Yaz Tipi fr Customer A1 A D E F G H 1 j K B Region ID 2 4 5 3 7 1 7 5 1 Customer 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara 286 Saray 287 Selim 288 Sembol 289 Serena 290 Sevil 291 Sinerji 292 Stella 293 Studio 294 Suite 295 anze 296 Tepe 297 Toprak 2 1 7 6 6 Customer Group WH DA GA WH IA DC EG DC MA WH Depot AK WH MA IA DC DC DA DC AK WH MA WH KA WH KA AK Depot Depot EG EG WH KA WH EG DC KA WH Depot GA Depot MA AK WH MA DC MA DC 1 3 3 6 3 298 Tpy 6 4 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 7 1 7 7 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Hazr Yaptr a Birlestir ve Ortala , 0,00 ,00 5,0 Ekle E Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Sil y Hizalama 15 Sayi Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 3 Customer Group EG WH KA WH EG DC 6 3 6 4 7 KA WH Depot GA Depot MA AK WH MA DC 1 7 7 MA DC 7 WH MA DC KA 6 3 1 Customer 295 anze 296 Tepe 297 Toprak 298 Toy 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 304 Turko 305 Tmlas 306 Uur 307 Ultra 308 Ulustrans 309 Umay 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay KM MAIN Hazr 1 5 4 5 1 3 EG DC DC AK IA Depot GA WH IA DC AK Depot WH EG DC KA WH KA EG DC DC KA DC AK DA WH 6 6 3 6 1 2 Wind Windo Customers Region Formula and Macro Questions x Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer A D E F H 1 J K L DC KA 1 Customer 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay 319 naldi 320 Unipack 321 niversal 322 ns 323 Vanessa 324 Vankim 325 Vardar 326 Vardarl 327 Vefa 328 Vemsan 329 Vera 330 Vetrina 331 Vetsan 332 Viens 333 Visys B Region ID Customer Group 5 IA DC 1 AK Depot 3 WH EG 6 6 WH KA 3 EG DC 6 DC KA 1 DC AK 2 DA WH 5 IA Depot 3 DC EG 7 Depot MA 2 WH DA 5 DCIA 7 MA WH 6 KA Depot 1 DC AK 3 EG WH 3 Depot EG 6 KA WH 5 IA Depot 6 Depot KA 3 EG Depot 4 WH GA Windo Window Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir a kopyala Biim Boyacisi Birletir ve Ortala Y 9 4,0 ,00 ,00 7,0 Ekle Sil Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Yaz Tipi 19 Hizalama Sayi Hcre A1 fx Customer A B D E F G H 1 L 1 Customer Region ID 6 3 4 3 1 5 331 Vetsan 332 Viens 333 Visys 334 Vivense 335 Vogue 336 Volpi 337 Wein 338 Weltew 339 Wood 340 Yaprak 341 Yasay 342 Yata 343 Yavuz Customer Group Depot KA EG Depot WH GA EG Depot AK Depot DCIA IA Depot DC AK DA Depot Depot KA DC GA IA WH 5 1 2 6 4 5 3 3 7 344 Yeni 345 Yldz 346 Yol 347 Yona WH EG DC EG MA DC DC MA DC AK DC EG 7 1 3 6 348 Ym 349 Yrkler 350 Yunus 351 Yurtii 352 Ycel 5 KA WH WHIA KA Depot MA DC 6 7 5 WHIA 353 Zebrano 354 Zevk Wit 1 AK WH KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Reg Hazr Pang 15 Hizalama 5 Sayi Stiller Hcr A1 D E F G H 1 J K 1 B Region ID 3 Yaz Tipi for Customer Customer Group WH EG DC EG 3 7 MA DC 7 DC MA 1 3 1 Customer 343 Yavuz 344 Yeni 345 Yldz 346 Yol 347 Yona 348 Ym 349 Yrkler 350 Yunus 351 Yurtii 352 Ycel 353 Zebrano 354 Zevk 355 Zivella 356 Zwick 6 DC AK DC EG KA WH WHIA KA Depot MA DC 5 6 7 5 WHIA AK WH 1 3 3 EG DC WH EG 357 358 359 360 361 362 363 364 365 Wi 366 KM MAIN Formula and Macro Questions, Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr PE Dosya Giris Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm 1 Calibri 11 AA 3 Metni kaydir Genel D H H 0 Yaptr Birletir ve Ortala kes Ea Kopyala Biim Boyacisi Pano A1 , 0,00 ,60 ,0 Ekle Sil Bicin Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Yaz Tipi Hizalama 154 Say 15 Hcreler fr Region ID C D E F G H 1 J J K L M A 1 Region ID 2 3 B Region Name 1 Akdeniz 2 Dou Anadolu 4 3 Ege 5 6 4 Gneydou Anadolu 5 Anadolu 6 Karadeniz DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 7 8 7 Marmara 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Window Windows Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara KM MAIN Hazr Branch Izmir Price Categories Products Customers H B D Aydn, ar 117203109 FOR EACH QUESTION INCLUDING MACROS, ASSIGN THE MACRO YOU WROTE TO THE YELLOW RECTANGLE SHAPE ABOVE THE QUESTION WHEN THE SHAPE IS CLICKED, THE MACRO SHOULD CLEAR THE DATA FIRST (IF ANY, STARTING FROM THE 6th ROW) IN THE COLUMNS REGARDING THE QUESTION (COLUMNS A G FOR Q1, ONLY COLU QUESTION 1 (15 points) QUESTION 2 (5 points) QUESTION 3 (5 points) Using macro, copy the sales for each branch to the following rows and fill the branch info Note that you should have 129 transactions in total Using the relevant formulas and Product Descr , write down the product ID for each transaction Note that the product ID is kept right before in the description Using VLOOKUP, product ID on the left and Products sheet, bring the additional price info of each product in each of the transactions If you cannot solve the question using macros, you can manually copy the data here as this step affects the others You will not get any points from this question in that case Branch Month Day Quantity Year Customer Nam Product Descr Product ID Product Name Product Type Sales Price Windows'u Etkinletir IMN H FOR Q2 etc ) QUESTION 4 (8 points) QUESTION 5 (10 points) QUESTION 6 (10 points) QUESTION 7 (5 points) QUESTION 8 (15 points) Using approximate VLOOKUP, product sales price on the left and Price Categories sheet, bring the Price Category info of each product (based on which interval its sales price falls into) in each of the transactions Using macro, calculate the total amounts (quantity sales price) for each transaction Using VLOOKUPS, region ID of the customer in Customers Using VLOOKUP, Customer Name of the customer group includes WH , it means the sheet and Regions sheet, bring the region name info of and Customers sheet, bring the customer corresponds to a warehouse Using macro, find each customer in each of the transactions customer group info of each out if the customers in each transaction corresponds to a customer in each of the warehouse Write YES or NO based on the outcome Hint You may need a nested formula transactions Copy and paste the results as a value within the macro Price Category Total Amount Region Name Customer Group Is Warehouse Windows'u Etkinletir Windowsu etkinlestirmek icin Avanlara aidi QUESTION 9 (12 points) It turns out that you had a problem with the deliveries on the following two dates 2019 08 11 and 2019 15 11 If the transaction date is any one of the above two, write YES to column Q Write NO otherwise Problem with the delivery Windows'u Etkinletir Windows'i etkinlestirmek icin Avarlar'a gidin Aydin agri 2 Microsoft Excel (run Etkinletirilemed Dosya Giris Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm A Otomatik Toplam HT H B Biim Dolgu 4,0 ,00 ,00 5,0 Ekle Sil Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller 22 Temizle Srala ve Filtre Bul ve Uygula Sec Dzenleme Hcreler 1 J Kes Calibri 11 A A 2 Metni kaydir Genel Ekopyala Yaptr Biim Boyacs K T A ra Birletir ve Ortala Pano Yaz Tipi Hizalama Say A1 fx Table 1 Total quantities sold per branch per year A B D E F G 1 Table 1 Total quantities sold per branch per year 2 YEAR 3 Branch 2015 2016 2017 2018 2019 2020 4 Istanbul 3140 2600 2700 1660 2600 4200 5 Izmir 1780 1920 3520 2720 2760 2680 6 Ankara 480 1600 1620 1060 300 780 7 PROBLEMS WITH THE VISUAL 8 9 9 YEARS 2015,2016,2017,2018,2019,2020 10 11 12 13 14 ALTERNATIVE VISUAL 15 16 4500 4000 3500 3000 2500 2000 1500 1000 500 Foto 17 Izmir Ankara Istanbul 18 19 2015 3140 2016 2600 2017 2700 2019 2600 20 2018 1660 1060 Istanbul Ankara 2020 4200 780 21 480 1600 1620 300 22 Izmir 1780 1920 3520 2720 2760 2680 23 24 Istanbul Ankara Izmir 25 Windows'u Etkinletir Windows'utetkintestirmek icin Avanlara aidin Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers III 0 Otomatik Toplam Calibri 11 2 Metni kaydir Genel Birletir ve Ortala ,0,00 ,00 5,0 Ekle Kes La Kopyala Yaptr Biim Boyacisi Pano J2 Sil 7 Biim Srala ve Fil Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Dolgu 2 Temizle Uygula Yaz Tipi 15 Hizalama 51 Sayi Hcreler Dzenleme fo B D E F G H 1 16 17 A 2500 2000 1500 1000 500 Izmir Ankara Istanbul 18 19 2015 3140 2018 1660 2019 2600 20 Istanbul 2016 2600 1600 1920 2017 2700 1620 3520 2020 4200 780 21 Ankara 480 1060 300 22 Izmir 1780 2720 2760 2680 23 24 Istanbul Ankara izmir 25 26 27 28 QUESTION 10 (15 points) 29 30 31 POINT OUT THE PROBLEMS WITH THE CHART ABOVE THEN, ADD A BETTER CHART TO THIS PAGE TO VISUALIZE TABLE 1, THAT ADDRESSES THE ISSUES YOU RAISED AND THAT TAKES THE DO'S AND DONT'S OF DATA VISUALIZATION INTO ACCOUNT 32 33 34 35 ALTHOUGH GENERATING THE ALTERNATIVE GRAPH HERE WITHIN EXCEL WOULD BE MORE CONVENIENT FOR YOU, YOU CAN GENERATE THE GRAPH SOMEWHERE ELSE (POWER BI etc ) AND PASTE IT HERE AS A PICTURE AS WELL 36 37 38 39 40 Windows'u Etkinletir Windows'u etkintestirmek icin Averlere gid Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir KI Hazr Price Categories Products Customers A B D K L M N O Month Year Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 16 140 22 100 13 160 7 16 240 3 11 400 10 16 160 E F G H Customer Name Product Descr 2018 Sara 3109EA243 Face Puff 2018 Horeka 3109UMY79 Scrub 2016 Volpi 3109UMY77 Hair Spa 2020 zgr 3109UMY45 Mac Brush 2019 Adria 3109EA243 Organic 2017 Dou 3109UMY54 Wax 2015 Kamel 3109EA518 Pomade 2020 Grup 3109EA915 Lotion 2017 Hasel 3109UMY12 Wax 2017 Hamann hellm 3109EA119 Volumizer 2020 istanbul 3109EA376 Loreal Series 2015 Ambiance 3109EA329 Biotique Facial Kit 2015 Roni 3109UMY74 Leave in Conditioner 2020 Ozan 3109UMY53 Curl Enhancing 2015 Brosit 3109EA915 Unscented 2018 Evim 3109EA516 Hair Straightner 2019 Ycel 3109UMY55 Bleach Cream 2017 Altin 3109UMY38 Lacto Oil Balance 2015 Hat 3109UMY53 Hair Wax 2019 Dion 3109UMY55 Curl Enhancing 2018 Hisar 3109EA826 Nature Pack 2018 Horeka 3109UMY68 Water Spray 2018 Universal 3109UMY2 Loreal Series 2018 Gzel 3109EA913 Root Pump 1 1 5 240 8 260 1 5 6 400 2 2 280 5 2 100 6 5 100 5 5 180 26 340 Boca 19 200 9 5 120 6 3 260 13 360 1 13 120 Windows'u Etkinletir Windowslettintestine A J K L M 25 26 27 28 29 30 31 32 33 34 35 36 37 B C D E F G H 1 1 13 120 2018 Gzel 3109EA913 Root Pump 10 14 120 2019 Keyf 3109EA826 Mac Brush 11 11 140 2017 CCK 3109EA617 Conditioning Mask 2 28 160 2020 Yeni 3109EA562 Face Pack 6 28 280 2015 Inter 3109UMY68 Scrub 3 1 320 2020 Wein 3109UMY59 Color Extending 10 20 400 2017 Linea 3109UMY49 Organic 4 9 9 280 2020 Sahne 3109EA521 Serum 5 3 140 2015 Gndodu 3109UMY49 Mousse 12 23 360 2017 Dou 3109EA956 Volumizer 5 17 360 2018 Gaziantepli 3109UMY54 Scrub 9 27 120 2017 LOTS 3109EA765 Gatsby Wax 11 7 380 2015 Tepe 3109EA562 Nature Pack 1 280 2017 Horeka 3109UMY38 Comb 12 24 320 2017 Wein 3109UMY60 Organic 4 23 280 2016 Altek 3109EA243 Facial Pack 10 14 380 2017 Akbulut 3109EA243 Scrub 6 8 360 2015 Hilal 3109UMY79 Massage Cream 3 16 400 2020 Ataizi 3109EA663 Room Freshener 11 23 320 2016 Tmlas 3109EA119 Leave in Conditioner 12 23 160 2020 CCK 3109UMY79 Feature 12 20 300 2020 Cennet 3109UMY55 Paraben Free 5 5 4 400 2019 Gallery 3109UMY4 Facial Pack 3 10 120 2016 Vetrina 3109EA765 Conditioning Mask 11 16 360 2019 Unotek 3109EA139 Mac Brush Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories 38 4 39 40 41 42 43 44 45 46 47 48 49 Windows Windows Regions KI MAIN Products Customers IVIOIILIT A B D E 1 J K L M 49 11 16 360 2 360 50 51 2 3 9 16 140 16 140 12 20 400 52 53 54 55 4 26 280 400 4 3 56 6 26 400 F G H 3109EA139 Mac Brush 3109UMY74 Hair Comb 3109EA329 Water Spray 3109EA956 Lotus Herbal 3109UMY59 Nova Straightner 3109EA444 Paraben Free 3109EA518 Texturizer 3109UMY68 Shahnaz Protein Mask 3109UMY69 Root Pump 3109UMY59 Hair Wax 3109UMY54 Oil 3109UMY45 Gel 3109UMY64 Comb 3109UMY52 Unscented 3109UMY49 Hair Wax 3109UMY23 Hair Wax 3109UMY24 Leave in Conditioner 57 10 12 2019 Unotek 2019 Hakzerler 2017 Zivella 2016 Recep 2015 Yona 2017 Mrs 2017 Armine 2015 Horeka 2018 Iglotek 2017 Art 2018 Akaln 2019 Selim 2016 Asil 2020 Mustafa 2019 ilke 2019 La 2019 Fze 100 8 120 58 59 1 10 9 2 100 60 2 320 61 11 23 100 3 22 320 62 63 14 260 2 5 64 18 140 65 10 23 360 66 67 68 69 70 71 72 73 KI Window Windows Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers A B 1 J K L M Month Day 2 Quantity 15 25 17 6 8 1 9 27 6 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMN ADDING A NEW CALCULATED COLUMNE ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLU THOUGH 8 3 1 13 8 6 9 4 28 11 24 2020 Fuga 9 8 1 5 D E F G H Year Customer Name Product Descr 100 2015 Saltolu 3109EA554 Face Capsule 340 2019 Messt 3109EA980 Nature Pack 120 2017 Ecem 3109UMY19 Alcohol Free 300 2019 Vankim 3109UMY55 Biotique Ayurveda 180 2017 Atila 3109EA770 Paraben Free 400 2018 Can 3109UMY71 Hair Wax 260 2016 Elize 3109UMY33 Nova Straightner 380 2020 Evim 3109EA312 Bleach Cream 240 2017 Ataizi 3109EA911 Massage Cream 360 2020 Tpy 3109EA956 Nova Straightner 240 3109EA966 Color Extending 200 2018 Gencay 3109UMY3 Hair Straightner 180 2017 ibir 3109EA444 Hair Color 360 2015 Line 3109EA437 Anti Frizz 140 2018 Tramer 3109EA424 Gel 280 2018 Wein 3109UMY71 Color Extending 200 2016 Adria 3109EA842 Clay 400 2016 Altnta 3109EA312 Hair Straightner 260 2016 Elano 3109EA163 Face Puff 340 2018 stikbal 3109EA554 Curling Tong 120 2015 Akmerta 3109EA424 Mousse 320 2018 Macitler 3109UMY26 Color Extending 200 2018 Ekto 3109EA872 Scrub 320 2019 Davenza 3109EA 749 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 17 9 8 1 28 12 5 1 29 9 1 12 3 29 4 6 8 2 10 3 10 12 25 Windows'u Windows'uneiki Products Customers Regions MAIN Formula and Macro Questions Price Categories azu A1 for Month B C D H 1 6 7 28 5 29 12 1 9 12 9 1 140 280 200 400 260 340 120 320 3 29 1 22 4 6 2 8 E 2018 Tramer 2018 Wein 2016 Adria 2016 Altnta 2016 Elano 2018 istikbal 2015 Akmerta 2018 Macitler 2018 Ekto 2019 Davenza 2017 A1 2020 Halaman 2017 Linea 2019 Visys 2015 Esste F G 3109EA424 Gel 3109UMY71 Color Extending 3109EA842 Clay 3109EA312 Hair Straightner 3109EA163 Face Puff 3109EA554 Curling Tong 3109EA424 Mousse 3109UMY26 Color Extending 3109EA872 Scrub 3109EA 749 Wahl Trimmer 3109EA813 Loreal Series 3109UMY36 Lacto Oil Balance 3109UMY36 Bleach Cream 3109EA437 Hair Wax 3109UMY1 Bleach Cream 10 3 10 200 23 4 5 26 27 12 25 320 7 21 360 7 12 320 00 10 0 0 0 0 0 400 19 1 25 260 12 26 220 1 2 3 24 5 6 7 8 59 20 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Month Quantity 21 Day 2 7 1 8 20 5 16 10 5 DO NOT MAKE ANY (CHANGING THE ORDER ADDING A NEW CALCULA ON THIS P YOU CAN CHANGE THE WID THOUG 9 21 8 11 8 19 4 6 10 8 12 4 1 30 Year Customer Name Product Descr 280 2020 ABC 3109EA479 Gel 160 2016 Horoz 3109UMY35 Gel 220 2016 Akmer 3109EA854 Hair Spray 400 2016 Grup 3109UMY76 Leave in Conditioner 220 2018 Volpi 3109EA445 Wahl Trimmer 140 2019 zgr 3109EA760 Loreal Series 320 2018 Dion 3109UMY35 Face Wash 240 2018 Trusa 3109UMY53 Water Spray 400 2018 Gkeler 3109EA864 Biotique Ayurveda 180 2020 Uur 3109EA423 Scrub 300 2015 Elize 3109UMY62 Makeup Brush 240 2016 New 3109EA549 Pomade 300 2016 Zebrano 3109UMY9 Root Pump 360 2019 Engince 3109UMY77 Root Pump 340 2015 imeks 3109UMY39 Bleach Cream 240 2019 Bedesten 3109EA333 Oil 160 2019 Mzf 3109EA955 Gatsby Wax 320 2018 Gktun 3109UMY53 Face Wash 240 2018 Art 3109UMY13 Loreal Series 300 2020 FM 3109EA760 Comb 260 2017 Cennet 3109EA854 Mousse 160 2017 Horoz 3109EA167 Gatsby Wax 360 2018 Vemsan 3109EA41 Hair Wax 180 2018 Zebrano 3109EA857 Curling Tong Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 22 11 26 11 29 1 8 1 30 12 20 9 14 12 14 2 27 5 4 28 11 6 13 Formula and Macro Questions Price Categories Products MAIN azir Customer 6 13 11 14 9 18 8 8 11 26 12 12 7 10 7 17 11 1 8 20 2 13 12 12 10 13 180 2018 Zebrano 3109EA857 Curling Tong 240 2015 Aydntepe 3109EA864 Mac Brush 380 2020 Doa 3109UMY2 Face Pack 180 2016 Mustafa 3109EA76 Clay 220 2019 Tmlas 3109EA459 Nova Straightner 320 2016 Adigzeller 3109EA854 Biotique Ayurveda 400 2019 Gzde 3109EA969 Curling Tong 380 2015 Akuapa 3109EA728 Water Spray 140 2016 Ozan 3109UMY68 Lotion 400 2020 Karahan 3109EA543 Gel 160 2015 Davenza 3109EA445 Heat Protectant 180 2015 Kadir 3109UMY68 Facial Pack 400 2016 Gkeler 3109EA115 Hair Spray 280 2015 Sara 3109EA938 Makeup Brush 220 2018 Asilzade 3109UMY62 Root Pump 120 2018 Keyf 3109EA851 Face Pack 320 2016 Gold 3109UMY76 Loreal Series 360 2015 znil 3109EA445 Feature 400 2018 anze 3109UMY76 Hair Color 240 2019 an 3109EA857 Comb 340 2017 imeks 3109EA173 Unscented 300 2017 Akvet 3109EA173 Mac Brush 280 2019 Horeka 3109UMY62 Blossom Face Wash 280 2020 Horeka 3109EA479 Face Puff 320 2020 Gallery 3109EA41 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 13 3 5 11 30 18 7 8 17 9 9 12 9 11 10 4 11 12 21 3 26 7 21 Wing Windo Region MAIN Formula and Macro Questions Price Categories Products Customers 11 30 120 7 18 320 8 17 360 9 9 400 12 9 240 11 10 340 4 11 300 12 21 280 2018 Keyf 2016 Gold 2015 znil 2018 anze 2019 an 2017 imeks 2017 Akvet 2019 Horeka 2020 Horeka 2020 Gallery 2018 Aker 2017 Atila 2020 Merve 2015 Zevk 2015 Baby 3109EA851 Face Pack 3109UMY76 Loreal Series 3109EA445 Feature 3109UMY76 Hair Color 3109EA857 Comb 3109EA173 Unscented 3109EA173 Mac Brush 3109UMY62 Blossom Face Wash 3109EA479 Face Puff 3109EA41 Wahl Trimmer 3109UMY62 Hair Comb 3109UMY63 Unscented 3109UMY8 Nova Straightner 3109UMY21 Texturizer 3109EA760 Nova Straightner 3 26 280 7 21 320 6 22 200 7 24 20 5 11 9 240 320 200 320 30 27 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Custom Hizalama Sayi Stiller Hcrel E F G H 1 J K L M N o Pano Yaz Tipi A1 for Price A B D 1 Price 2 Lower Bound Upper Bound Category 3 0,00 17,99 Basic 4 18,00 59,99 Premium 5 60,00 140,00 Deluxe 6 7 8 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 9 10 11 12 13 14 15 16 17 18 19 20 21 E F G H 1 K L D Sales Price 57,89 53,70 39,83 20,91 64,78 56,19 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 10,00 A Product ID 2 3109UMY49 3109UMY23 3109EA39 3109EA476 3109UMY56 3109UMY2 3109EA677 3109UMY33 0 3109EA964 1 3109EA33 2 3109EA835 3 3109UMY52 4 3109EA538 5 3109UMY73 6 3109EA539 7 3109EA347 8 3109UMY21 9 3109UMY15 LO 3109EA329 1 3109UMY44 2 3109EA854 3 3109EA545 4 3109UMY8 5 3109UMY79 MAIN B Product Name Alcohol Free Anti Frizz Biotique Ayurveda Biotique Facial Kit Bleach Cream Blossom Face Wash Clay Color Extending Comb Conditioning Mask Curl Enhancing Curling Tong Dry Shampoo Face Capsule Face Pack Face Puff Face Wash Facial Pack Feature Foam Gatsby Wax Gel Hair Caps Hair Color Formula and Macro Questions c Product Type Bulk Private Label Private Label Bulk Bulk Bulk Bulk Packaged Private Label Packaged Packaged Bulk Private Label Packaged Private Label Packaged Packaged Private Label Packaged Bulk Bulk Bulk Private Label Bulk Data Visualization 6,78 28,27 9,66 44,33 62,44 49,30 65,43 62,78 69,16 50,02 13,69 52,78 22,64 53,41 32,97 52,98 7,34 Branch Istanbul Windo Windows Customers Regions Branch Ankara Branch Izmir Price Categories Products Hazr D E F G H 1 J L A1 fx Product ID A B C 1 Product ID Product Name Product Type 23 3109EA545 Gel Bulk 24 3109UMY8 Hair Caps Private Label 25 3109UMY79 Hair Color Bulk 26 3109UMY6 Hair Comb Packaged 27 3109EA272 Hair Gel Packaged 28 3109EA 31 Hair Spa Bulk 29 3109UMY13 Hair Spray Private Label 30 3109UMY80 Hair Straightner Packaged 31 3109EA560 Hair Wax Bulk 32 3109UMY66 Heat Protectant Private Label 33 3109EA542 Lacto Oil Balance Private Label 34 3109UMY63 Leave in Conditioner Private Label 35 3109UMY68 Loreal Series Private Label 36 3109UMY65 Lotion Private Label 37 3109EA 34 Lotus Herbal Private Label 38 3109EA667 Mac Brush Private Label 39 3109EA 743 Makeup Brush Bulk 40 3109UMY51 Massage Cream Private Label 41 3109EA524 Mousse Packaged 42 3109EA553 Nature Pack Packaged 43 3109UMY74 Nova Straightner Private Label 44 3109EA918 Oil Private Label 45 3109UMY57 Organic Private Label 46 3109UMY19 Paraben Free Bulk MAIN Formula and Macro Questions Formula and Macro Questions Data Visualization Hazr Sales Price 32,97 52,98 7,34 47,91 59,57 34,57 55,55 64,49 48,43 51,65 28,08 33,40 49,56 35,49 60,57 39,28 13,90 62,83 21,25 19,02 24,89 11,01 24,52 60,01 Wind Windo Region Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers AL roduct ID D E F G H 1 K A 1 Product ID 41 3109EA524 42 3109EA553 43 3109UMY74 44 3109EA918 45 3109UMY57 46 3109UMY19 47 3109EA228 48 3109EA269 49 3109UMY59 50 3109EA625 51 3109EA326 52 3109UMY16 53 3109EA555 54 3109UMY71 55 3109UMY62 56 3109UMY70 57 3109UMY17 58 3109EA536 59 3109EA911 60 3109UMY37 B Product Name Mousse Nature Pack Nova Straightner Oil Organic Paraben Free Pomade Room Freshener Root Pump Scissor Scrub Serum Shahnaz Protein Mask Skin Toner Texturizer Trimmer Unscented Volumizer Wahl Trimmer Water Spray Wax Product Type Packaged Packaged Private Label Private Label Private Label Bulk Bulk Private Label Private Label Bulk Private Label Private Label Bulk Bulk Packaged Packaged Bulk Bulk Private Label Packaged Packaged Sales Price 21,25 19,02 24,89 11,01 24,52 60,01 12,31 6,86 39,00 14,79 26,20 43,27 37,50 39,07 16,86 20,27 41,74 11,05 68,42 29,39 58,86 61 3109EA612 62 63 Wi 64 K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr AT D E F G H 1 K B Region ID 2 3 5 5 5 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 1 5 F Customer Customer Group DA Depot DC EG IA DC DC IA IA WH DA WH Depot AK IA Depot IA DC Depot DA KA Depot Depot EG Depot MA EG DC 5 2 A 1 Customer 2 A1 3 Abba 4 ABC 5 Abr 6 Acar 7 Aceka 8 Active 9 Ada 10 Adallar 11 Adem 12 Adigzeller 13 Adria 14 Ada 15 Airpak 16 AK 17 Akabe 18 Akaln 19 Akar 20 Akay 21 Akbulut 22 Akdeniz 23 Akdin 24 Aker 25 Akif 6 3 3 7 3 7 WH MA 3 3 2 EG WH DA WH 3 DC EG 7 WH MA 7 DC MA 6 KA Depot 2 Depot DA 4 GA DC 5 Depot IA Formula and Macro Questions W Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Tapisi K 7 A a Birletir ve Ortala 600 CKIE 7 Y Biim Boyacs Pano A1 IdUIU afak nucre Biimlendirme Bicimlendir Stilleri Stiller Hizalama Sayi Hcreler Yaz Tipi 1 for Customer A B D E F G H 1 J J K L Region ID 2 4 5 5 5 2 5 7 Customer Group Depot DA GA DC Depot IA IA DC IA WH DC DA IA DC MA DC EG Depot DA WH DC MA Depot IA DC KA GA Depot EG DC IA WH WH MA 3 2 7 1 Customer 23 Akdin 24 Aker 25 Akif 26 Aki 27 Akkurt 28 Akmer 29 Akmertas 30 Akport 31 Aksa 32 Aksel 33 Aktiford 34 Akturan 35 Akuapa 36 Akvet 37 Akyol 38 Akyrekler 39 Alfa 40 Alg 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen KI MAIN Hazr 5 6 4 3 5 7 6 KA WH 3 EG WH 5 IA Depot 6 DC KA 6 DC KA 3 DC EG 3 EG Depot Formula and Macro Questions Windo Window Customers Regions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 D E F G H 1 K L I Region ID 3 5 6 A 1 Customer 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen 47 Alpplast 48 Altek 49 Alternatif 50 Altin 51 Altinel 52 Altnta 53 Always 54 Ambiance 55 Ankamar 56 Anr 6 3 3 5 1 for Customer Customer Group EG WH IA Depot DC KA DC KA DC EG EG Depot IA Depot DC AK DC KA MA WH WH KA IA Depot MA WH 6 7 6 5 7 GA DC 4 2 3 6 6 6 57 Ant 58 Antik 59 Ardini 60 Ari 61 Armine 62 Art 63 Artem 64 AS DA DC EG Depot DC KA KA WH KA WH DC EG WH MA DA DC WHIA WH MA 3 7 2 5 7 Windows Windowsure Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products 7 5 7 5 1 1 6 2 4 7 1 64 AS 65 Asil 66 Asilzade 67 Aslanlar 68 Asya 69 Ataizi 70 Atila 71 Atlas 72 Atlyem 73 Ats 74 Autoprotect 75 Aydntepe 76 Baby 77 Bari 78 Bedesten 79 Bellona 80 Berr 81 Berrak 82 Beta 83 Beys 84 Bosart 85 BRN 86 Buka 87 Brosit WH MA Depot IA Depot MA IA DC AK DC AK DC WH KA Depot DA GA Depot DC MA AK DC AK Depot DC DA Depot AK WH EG GA Depot WH KA Depot IA DC DA EG DC Depot IA IA DC 1 2 1 3 4 6 5 2 3 5 5 5 WHIA 4 Depot GA Windows'u Windows uretki Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr 85 BRN 5 86 Buka 5 87 Brosit 4 7 4 5 IA DC WHIA Depot GA MA Depot Depot GA IA Depot IA DC WH EG Depot AK DC KA MA Depot MA DC 5 3 1 6 7 7 4 WH GA 88 By 89 Can 90 CCK 91 Cennet 92 Cihangir 93 Classi 94 Comfort 95 Country 96 Cyk 97 an 98 alkan 99 etmen 100 iek 101 imen 102 Doruk 103 Davenza 104 Deka 105 Detay 106 Dion 107 Dizayn 108 Doa 7 WH MA 5 6 7 6 7 IA DC KA Depot MA WH DC KA Depot MA GA DC DC KA Depot KA AK DC WHAK 4 6 6 1 Wind 1 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Region Hazr Pano Yaz Tipi Hizalama 15 Sayi Stiller Hcreler A1 for Customer B D E G H J K L Region ID 6 1 1 2 5 4 7 6 4 5 7 A 1 Customer 106 Dion 107 Dizayn 108 Doa 109 Dota 110 Dou 111 Duayen 112 Ecem 113 EFFE 114 Ekto 115 Elano 116 Elips 117 Elize 118 Elve 119 Engince 120 Enne 121 Erbil 122 ESEREV 123 Esste 124 Evim 125 Flash 126 FM 127 Forml 128 Fuga 129 Fze C Customer Group Depot KA AK DC WHAK DA Depot IA DC WH GA DC MA KA Depot Depot GA IA DC Depot MA GA DC KA DC GA WH DC EG DA Depot IA WH EG DC MA DC Depot MA Depot EG KA DC DA DC MA WH 4 6 4 3 2 5 3 3 7 7 3 6 2 7 Windov Windows Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Region ID Customer Group 6 KA DC 2 DA DC 7 MA WH 5 3 IA WH EG DC DC EG 3 2 DA DC 4 GA WH WHAK 1 AK DC 1 5 1 1 Customer 127 Forml 128 Fuga 129 Fze 130 Gala 131 Gallery 132 Gaziantepli 133 Gencay 134 Genkan 135 Geomekanik 136 Get 137 Giri 138 Gisan 139 Gmaks 140 Gold 141 Gkeler 142 Gktun 143 Gral 144 Gzde 145 Grb 146 Grup 147 Gler 148 Gleryz 149 Glah 150 Gnaydnlar KN MAIN Hazr 2 DCIA AK Depot DC DA DA WH DC EG 2 3 5 IA DC Depot IA 5 6 WH KA 6 DC KA 2 7 7 4 WH DA MA Depot Depot MA GA DC DA DC 2 Window Windows Customers Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer D E F G H K L 1 Customer Region ID 148 Gleryz 7 149 Glah 4 150 Gnaydinlar 2 151 Gndodu 4 152 Gnhanlar 6 153 Grlek 1 154 Grman 7 155 Grah 3 156 Gzel 6 157 Haidi 7 158 Hakan 7 159 Hakk 3 160 Hakmet 3 161 Hakzerler 1 162 Halaman 4 163 Hamann hellmann 6 164 Harman 2 165 Harmanc 2 166 Has 5 167 Hasel 1 168 Hat 2 169 Hellmann 7 170 Hevin 3 171 Hilal 5 C Customer Group Depot MA GA DC DA DC DC GA Depot KA AK Depot MA WH Depot EG DC KA MA Depot Depot MA EG WH Depot EG AK DC WH GA KA Depot WH DA DA DC IA Depot Depot AK WH DA WH MA EG WH IA WH Wind Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Regio A D E F G H M B Region ID 7 3 1 Customer 169 Hellmann 170 Hevin 171 Hilal 172 Hisar 173 Hmk 174 Horeka 5 7 4 Customer Group WH MA EG WH IA WH MA Depot DC GA MA DC 7 3 WH EG 6 Depot KA IA WH 5 2 175 Horoz 176 Hseyin 177 Ingbank 178 Irmak 179 Iglotek 180 ihlas 181 ikizler 182 ilke 183 imeks 4 DA WH GA DC DA WH WH MA 2 7 3 3 184 Img 6 3 2 185 inan 186 inan 187 inci 188 inter 189 Interrior 190 stanbul 191 istikbal 192 ibir 1 2 3 2 EG WH EG Depot WH KA EG Depot Depot DA AK DC DA DC Depot EG DC DA AK Depot WH KA 1 6 Windows'u B Windows u etkin Customers Regions K4 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr do kes Calibri 11 AN Metni kaydir Genel 1 Yaptr Birletir ve Ortala Ekle Sil 4,0 ,00 ,00 5,0 Biim Ea Kopyala Biim Boyacs Pano A1 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Hizalama Say Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 2 1 6 7 4 3 1 1 5 4 5 1 Customer 190 stanbul 191 stikbal 192 ibir 193 Just 194 Kadir 195 Kadri 196 Kalsan 197 Kalyon 198 Kamel 199 Ka met 200 Kapars 201 Kar 202 Karagn 203 Karahan 204 Karakter 205 Karat 206 Kardem 207 Kargili 208 Kavas 209 Kelebek 210 Keops 211 keyf 212 Kilim 213 Koala 1 Customer Group DC DA AK Depot WH KA Depot MA Depot GA EG WH AK Depot AK DC IA WH GA DC IA Depot AK WH Depot DA WH DA GA WH DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK 2 2 4 7 5 3 6 1 6 1 6 1 Windows Windows'un Customers Regions K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Calibri A A VY E' Metni kaydir Genel EH FH Yaptr T Birletir ve Ortala , 0,00 ,00,0 Ekle Sil Y Y Ea Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Yaz Tipi Hizalama Sayi Hcr for Customer D E F G H 1 J K B Region ID 7 5 3 6 1 A 1 Customer 205 Karat 206 Kardem 207 Kargile 208 Kavas 209 Kelebek 210 Keops 211 Keyf 212 Kilim 213 Koala 214 Koray 215 Kozza 216 Kukla 6 1 6 1 1 6 Customer Group DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK AK DC WH KA EG WH Depot IA WH EG DC DA DC IA DC KA DC MA DC AK DC EG AK Depot DC DA WHAK 3 5 217 La 218 Lazzoni 3 219 Lenova 2 5 6 7 1 3 220 Leonart 221 Line 222 Linea 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge KI MAIN Hazr 1 2 1 4 4 WH GA Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Red Pano 15 Hizalama 5 Sayi Stiller Hcreler A1 D E F H 1 J L M 1 Customer 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge 229 Lutra Yaz Tipi for Customer B Region ID Customer Group 1 DC AK 3 DC EG 1 AK Depot 2 DC DA 1 WHAK 4 WH GA 2 DA DC 1 Depot AK 5 IA WH 1 AK Depot 3 EG Depot 3 Depot EG 2 DA DC 3 EG WH 7 Depot MA 4 Depot GA 2 WH DA 230 Luxxa 231 Macitler 232 Marka 233 Mass 234 Maxx 235 Maya 236 Mazzini 237 MD 238 Merve 239 Mesa 4 GA DC 3 2 240 Messt 241 Metropool 242 MG 243 Millennium 244 Mirage 245 Monalisa 246 Montel 3 DC EG DC DA DC EG KA Depot DCIA 6 5 4 4 GA WH Windows'u Windows'unetki Customers Regions MAIN Hazr Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir Fat Birlestir ve Ortala 7 Biim Boyacisi 4,000 ,00 ,0 Ekle Koullu Tablo Olarak Hucre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Hizalama Sayi Hu Yaz Tipi fr Customer A1 A E F G H 1 J J K 1 Customer 244 Mirage 245 Monalisa 246 Montel 247 Mrs 248 Mustafa 249 Muzaffer 250 Mzf 251 NDesign 252 Neptun 253 Nero 254 Neva 255 Neveda 256 New 257 Newjoy 258 Nil 259 Nisa 260 Nurelik 261 Nans 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan B D Region ID Customer Group 6 KA Depot 5 DC IA 4 GA WH 4 GA DC 4 DC GA 1 AK DC 1 AK WH 6 KA Depot 7 MA DC 3 EG DC 2 DC DA 3 EG WH 6 KA Depot 3 Depot EG 5 IA WH 5 WHIA 7 MA WH 6 WH KA 5 IA DC 1 DC AK 7 Depot MA 1 DC AK 4 GA DC 3 EG Depot Formula and Macro Questions Data Visualization w wi Customers RO MAIN Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Pano Yaz Tipi Hizalama Sayi Stiller H A1 for Customer A B D E F G H 1 K Region ID 5 1 7 1 4 3 Customer Group IA DC DC AK Depot MA DC AK GA DC EG Depot GA WH DA Depot MA Depot EG DC 4 2 7 3 5 IA DC 5 1 Customer 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan 268 z 269 zgr 270 znil 271 ztrkler 272 Polatlar 273 Rada 274 Ranseyman 275 Ravhome 276 Ray 277 Recep 278 Reform 279 Rengarenk 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara MAIN Hazr 1 6 5 4 2 1 IA Depot AK WH KA DC IA DC WH GA WH DA AK WH WH DA GA WH IA DC EG DC MA WH Depot AK 2 4 5 3 7 1 Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Re Yaptr Birletir ve Ortala CD E Kopyala Biim Boyacisi Pano 15 4,0,00 60 ,0 Ekle Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Hizalama Sayi Yaz Tipi fr Customer A1 A D E F G H 1 j K B Region ID 2 4 5 3 7 1 7 5 1 Customer 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara 286 Saray 287 Selim 288 Sembol 289 Serena 290 Sevil 291 Sinerji 292 Stella 293 Studio 294 Suite 295 anze 296 Tepe 297 Toprak 2 1 7 6 6 Customer Group WH DA GA WH IA DC EG DC MA WH Depot AK WH MA IA DC DC DA DC AK WH MA WH KA WH KA AK Depot Depot EG EG WH KA WH EG DC KA WH Depot GA Depot MA AK WH MA DC MA DC 1 3 3 6 3 298 Tpy 6 4 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 7 1 7 7 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Hazr Yaptr a Birlestir ve Ortala , 0,00 ,00 5,0 Ekle E Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Sil y Hizalama 15 Sayi Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 3 Customer Group EG WH KA WH EG DC 6 3 6 4 7 KA WH Depot GA Depot MA AK WH MA DC 1 7 7 MA DC 7 WH MA DC KA 6 3 1 Customer 295 anze 296 Tepe 297 Toprak 298 Toy 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 304 Turko 305 Tmlas 306 Uur 307 Ultra 308 Ulustrans 309 Umay 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay KM MAIN Hazr 1 5 4 5 1 3 EG DC DC AK IA Depot GA WH IA DC AK Depot WH EG DC KA WH KA EG DC DC KA DC AK DA WH 6 6 3 6 1 2 Wind Windo Customers Region Formula and Macro Questions x Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer A D E F H 1 J K L DC KA 1 Custo

Question

A B D K L M N O Month Year  Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 16 140 22 100 13 160 7 16 240 3 11 400 10 16 160 E F G H Customer Name Product Descr  2018 Sara 3109EA243 Face Puff 2018 Horeka 3109UMY79 Scrub 2016 Volpi 3109UMY77 Hair Spa 2020 zgr 3109UMY45 Mac Brush 2019 Adria 3109EA243 Organic 2017 Dou 3109UMY54 Wax 2015 Kamel 3109EA518 Pomade 2020 Grup 3109EA915 Lotion 2017 Hasel 3109UMY12 Wax 2017 Hamann hellm  3109EA119 Volumizer 2020 istanbul 3109EA376 Loreal Series 2015 Ambiance 3109EA329 Biotique Facial Kit 2015 Roni 3109UMY74 Leave in Conditioner 2020 Ozan 3109UMY53 Curl Enhancing 2015 Brosit 3109EA915 Unscented 2018 Evim 3109EA516 Hair Straightner 2019 Ycel 3109UMY55 Bleach Cream 2017 Altin 3109UMY38 Lacto Oil Balance 2015 Hat 3109UMY53 Hair Wax 2019 Dion 3109UMY55 Curl Enhancing 2018 Hisar 3109EA826 Nature Pack 2018 Horeka 3109UMY68 Water Spray 2018 Universal 3109UMY2 Loreal Series 2018 Gzel 3109EA913 Root Pump 1 1 5 240 8 260 1 5 6 400 2 2 280 5 2 100 6 5 100 5 5 180 26 340 Boca 19 200 9 5 120 6 3 260 13 360 1 13 120 Windows'u Etkinletir Windowslettintestine A J K L M 25 26 27 28 29 30 31 32 33 34 35 36 37 B C D E F G H 1 1 13 120 2018 Gzel 3109EA913 Root Pump 10 14 120 2019 Keyf 3109EA826 Mac Brush 11 11 140 2017 CCK 3109EA617 Conditioning Mask 2 28 160 2020 Yeni 3109EA562 Face Pack 6 28 280 2015 Inter 3109UMY68 Scrub 3 1 320 2020 Wein 3109UMY59 Color Extending 10 20 400 2017 Linea 3109UMY49 Organic 4 9 9 280 2020 Sahne 3109EA521 Serum 5 3 140 2015 Gndodu 3109UMY49 Mousse 12 23 360 2017 Dou 3109EA956 Volumizer 5 17 360 2018 Gaziantepli 3109UMY54 Scrub 9 27 120 2017 LOTS 3109EA765 Gatsby Wax 11 7 380 2015 Tepe 3109EA562 Nature Pack 1 280 2017 Horeka 3109UMY38 Comb 12 24 320 2017 Wein 3109UMY60 Organic 4 23 280 2016 Altek 3109EA243 Facial Pack 10 14 380 2017 Akbulut 3109EA243 Scrub 6 8 360 2015 Hilal 3109UMY79 Massage Cream 3 16 400 2020 Ataizi 3109EA663 Room Freshener 11 23 320 2016 Tmlas 3109EA119 Leave in Conditioner 12 23 160 2020 CCK 3109UMY79 Feature 12 20 300 2020 Cennet 3109UMY55 Paraben Free 5 5 4 400 2019 Gallery 3109UMY4 Facial Pack 3 10 120 2016 Vetrina 3109EA765 Conditioning Mask 11 16 360 2019 Unotek 3109EA139 Mac Brush Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories 38 4 39 40 41 42 43 44 45 46 47 48 49 Windows Windows Regions KI MAIN Products Customers   IVIOIILIT A B D E 1 J K L M 49 11 16 360 2 360 50 51 2 3 9 16 140 16 140 12 20 400 52 53 54 55 4 26 280 400 4 3 56 6 26 400 F G H 3109EA139 Mac Brush 3109UMY74 Hair Comb 3109EA329 Water Spray 3109EA956 Lotus Herbal 3109UMY59 Nova Straightner 3109EA444 Paraben Free 3109EA518 Texturizer 3109UMY68 Shahnaz Protein Mask 3109UMY69 Root Pump 3109UMY59 Hair Wax 3109UMY54 Oil 3109UMY45 Gel 3109UMY64 Comb 3109UMY52 Unscented 3109UMY49 Hair Wax 3109UMY23 Hair Wax 3109UMY24 Leave in Conditioner 57 10 12 2019 Unotek 2019 Hakzerler 2017 Zivella 2016 Recep 2015 Yona 2017 Mrs 2017 Armine 2015 Horeka 2018 Iglotek 2017 Art 2018 Akaln 2019 Selim 2016 Asil 2020 Mustafa 2019 ilke 2019 La 2019 Fze 100 8 120 58 59 1 10 9 2 100 60 2 320 61 11 23 100 3 22 320 62 63 14 260 2 5 64 18 140 65 10 23 360 66 67 68 69 70 71 72 73 KI Window Windows Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers A B 1 J K L M Month Day 2 Quantity 15 25 17 6 8 1 9 27 6 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMN ADDING A NEW CALCULATED COLUMNE ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLU THOUGH 8 3 1 13 8 6 9 4 28 11 24 2020 Fuga 9 8 1 5 D E F G H Year Customer Name Product Descr  100 2015 Saltolu 3109EA554 Face Capsule 340 2019 Messt 3109EA980 Nature Pack 120 2017 Ecem 3109UMY19 Alcohol Free 300 2019 Vankim 3109UMY55 Biotique Ayurveda 180 2017 Atila 3109EA770 Paraben Free 400 2018 Can 3109UMY71 Hair Wax 260 2016 Elize 3109UMY33 Nova Straightner 380 2020 Evim 3109EA312 Bleach Cream 240 2017 Ataizi 3109EA911 Massage Cream 360 2020 Tpy 3109EA956 Nova Straightner 240 3109EA966 Color Extending 200 2018 Gencay 3109UMY3 Hair Straightner 180 2017 ibir 3109EA444 Hair Color 360 2015 Line 3109EA437 Anti Frizz 140 2018 Tramer 3109EA424 Gel 280 2018 Wein 3109UMY71 Color Extending 200 2016 Adria 3109EA842 Clay 400 2016 Altnta 3109EA312  Hair Straightner 260 2016 Elano 3109EA163 Face Puff 340 2018 stikbal 3109EA554 Curling Tong 120 2015 Akmerta 3109EA424 Mousse 320 2018 Macitler 3109UMY26 Color Extending 200 2018 Ekto 3109EA872 Scrub 320 2019 Davenza 3109EA 749 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 17 9 8 1 28 12 5 1 29 9 1 12 3 29 4 6 8 2 10 3 10 12 25 Windows'u Windows'uneiki Products Customers Regions            MAIN Formula and Macro Questions Price Categories azu A1 for Month B C D H 1 6  7 28 5 29 12 1 9 12 9 1 140 280 200 400 260 340 120 320 3 29 1 22 4 6 2 8 E 2018 Tramer 2018 Wein 2016 Adria 2016 Altnta 2016 Elano 2018 istikbal 2015 Akmerta 2018 Macitler 2018 Ekto 2019 Davenza 2017 A1 2020 Halaman 2017 Linea 2019 Visys 2015 Esste F G 3109EA424 Gel 3109UMY71 Color Extending 3109EA842 Clay 3109EA312 Hair Straightner 3109EA163 Face Puff 3109EA554 Curling Tong 3109EA424 Mousse 3109UMY26 Color Extending 3109EA872 Scrub 3109EA 749 Wahl Trimmer 3109EA813 Loreal Series 3109UMY36 Lacto Oil Balance 3109UMY36 Bleach Cream 3109EA437 Hair Wax 3109UMY1 Bleach Cream 10 3 10 200 23  4  5 26 27 12 25 320 7 21 360 7 12 320 00 10 0 0 0 0 0 400 19 1 25 260 12 26 220 1 2 3 24 5 6 7 8 59 20   MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Month Quantity 21 Day 2 7 1 8 20 5 16 10 5 DO NOT MAKE ANY (CHANGING THE ORDER ADDING A NEW CALCULA ON THIS P YOU CAN CHANGE THE WID THOUG 9 21 8 11 8 19 4 6 10 8 12 4 1 30 Year Customer Name Product Descr  280 2020 ABC 3109EA479 Gel 160 2016 Horoz 3109UMY35 Gel 220 2016 Akmer 3109EA854 Hair Spray 400 2016 Grup 3109UMY76 Leave in Conditioner 220 2018 Volpi 3109EA445 Wahl Trimmer 140 2019 zgr 3109EA760 Loreal Series 320 2018 Dion 3109UMY35 Face Wash 240 2018 Trusa 3109UMY53 Water Spray 400 2018 Gkeler 3109EA864 Biotique Ayurveda 180 2020 Uur 3109EA423 Scrub 300 2015 Elize 3109UMY62 Makeup Brush 240 2016 New 3109EA549 Pomade 300 2016 Zebrano 3109UMY9 Root Pump 360 2019 Engince 3109UMY77 Root Pump 340 2015 imeks 3109UMY39 Bleach Cream 240 2019 Bedesten 3109EA333 Oil 160 2019 Mzf 3109EA955 Gatsby Wax 320 2018 Gktun 3109UMY53 Face Wash 240 2018 Art 3109UMY13 Loreal Series 300 2020 FM 3109EA760 Comb 260 2017 Cennet 3109EA854 Mousse 160 2017 Horoz 3109EA167 Gatsby Wax 360 2018 Vemsan 3109EA41 Hair Wax 180 2018 Zebrano 3109EA857 Curling Tong     Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 22 11 26 11 29 1 8 1 30 12 20 9 14 12 14 2 27 5 4 28 11 6 13 Formula and Macro Questions Price Categories Products MAIN azir Customer 6 13 11 14 9 18 8 8 11 26 12 12 7 10 7 17 11 1 8 20 2 13 12 12 10 13 180 2018 Zebrano 3109EA857 Curling Tong 240 2015 Aydntepe 3109EA864 Mac Brush 380 2020 Doa 3109UMY2 Face Pack 180 2016 Mustafa 3109EA76 Clay 220 2019 Tmlas 3109EA459 Nova Straightner 320 2016 Adigzeller 3109EA854 Biotique Ayurveda 400 2019 Gzde 3109EA969 Curling Tong 380 2015 Akuapa 3109EA728 Water Spray 140 2016 Ozan 3109UMY68 Lotion 400 2020 Karahan 3109EA543 Gel 160 2015 Davenza 3109EA445 Heat Protectant 180 2015 Kadir 3109UMY68 Facial Pack 400 2016 Gkeler 3109EA115 Hair Spray 280 2015 Sara 3109EA938 Makeup Brush 220 2018 Asilzade 3109UMY62 Root Pump 120 2018 Keyf 3109EA851 Face Pack 320 2016 Gold 3109UMY76 Loreal Series 360 2015 znil 3109EA445 Feature 400 2018 anze 3109UMY76 Hair Color 240 2019 an 3109EA857 Comb 340 2017 imeks 3109EA173 Unscented 300 2017 Akvet 3109EA173 Mac Brush 280 2019 Horeka 3109UMY62 Blossom Face Wash 280 2020 Horeka 3109EA479 Face Puff 320 2020 Gallery 3109EA41 Wahl Trimmer   Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 13 3 5 11 30 18 7 8 17 9 9 12 9 11 10 4 11 12 21 3 26 7 21 Wing Windo Region MAIN Formula and Macro Questions Price Categories Products Customers 11 30 120 7 18 320 8 17 360 9 9 400 12 9 240 11 10 340 4 11 300 12 21 280 2018 Keyf 2016 Gold 2015 znil 2018 anze 2019 an 2017 imeks 2017 Akvet 2019 Horeka 2020 Horeka 2020 Gallery 2018 Aker 2017 Atila 2020 Merve 2015 Zevk 2015 Baby 3109EA851 Face Pack 3109UMY76 Loreal Series 3109EA445 Feature 3109UMY76 Hair Color 3109EA857 Comb 3109EA173 Unscented 3109EA173 Mac Brush 3109UMY62 Blossom Face Wash 3109EA479 Face Puff 3109EA41 Wahl Trimmer 3109UMY62 Hair Comb 3109UMY63 Unscented 3109UMY8 Nova Straightner 3109UMY21 Texturizer 3109EA760 Nova Straightner 3 26 280 7 21 320 6 22 200 7 24 20 5 11 9 240 320 200 320 30 27 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Custom Hizalama Sayi Stiller Hcrel E F G H 1 J K L M N o Pano Yaz Tipi A1 for Price A B D 1 Price 2 Lower Bound Upper Bound Category 3 0,00 17,99 Basic 4 18,00 59,99 Premium 5 60,00 140,00 Deluxe 6 7 8 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 9 10 11 12 13 14 15 16 17 18 19 20 21 E F G H 1 K L D Sales Price 57,89 53,70 39,83 20,91 64,78 56,19 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 10,00 A Product ID 2  3109UMY49 3109UMY23 3109EA39 3109EA476 3109UMY56 3109UMY2 3109EA677 3109UMY33 0 3109EA964 1 3109EA33 2 3109EA835 3 3109UMY52 4 3109EA538 5 3109UMY73 6 3109EA539 7 3109EA347 8 3109UMY21 9 3109UMY15 LO 3109EA329 1 3109UMY44 2 3109EA854 3 3109EA545 4 3109UMY8 5 3109UMY79 MAIN B Product Name Alcohol Free Anti Frizz Biotique Ayurveda Biotique Facial Kit Bleach Cream Blossom Face Wash Clay Color Extending Comb Conditioning Mask Curl Enhancing Curling Tong Dry Shampoo Face Capsule Face Pack Face Puff Face Wash Facial Pack Feature Foam Gatsby Wax Gel Hair Caps Hair Color Formula and Macro Questions c Product Type Bulk Private Label Private Label Bulk Bulk Bulk Bulk Packaged Private Label Packaged Packaged Bulk Private Label Packaged Private Label Packaged Packaged Private Label Packaged Bulk Bulk Bulk Private Label Bulk Data Visualization 6,78 28,27 9,66 44,33 62,44 49,30 65,43 62,78 69,16 50,02 13,69 52,78 22,64 53,41 32,97 52,98 7,34 Branch Istanbul Windo Windows Customers Regions Branch Ankara Branch Izmir Price Categories Products Hazr D E F G H 1 J L A1 fx Product ID A B C 1 Product ID Product Name Product Type 23 3109EA545 Gel Bulk 24 3109UMY8 Hair Caps Private Label 25 3109UMY79 Hair Color Bulk 26 3109UMY6 Hair Comb Packaged 27 3109EA272 Hair Gel Packaged 28 3109EA 31 Hair Spa Bulk 29 3109UMY13 Hair Spray Private Label 30 3109UMY80 Hair Straightner Packaged 31 3109EA560 Hair Wax Bulk 32 3109UMY66 Heat Protectant Private Label 33 3109EA542 Lacto Oil Balance Private Label 34 3109UMY63 Leave in Conditioner Private Label 35 3109UMY68 Loreal Series Private Label 36 3109UMY65 Lotion Private Label 37 3109EA 34 Lotus Herbal Private Label 38 3109EA667 Mac Brush Private Label 39 3109EA 743 Makeup Brush Bulk 40 3109UMY51 Massage Cream Private Label 41 3109EA524 Mousse Packaged 42 3109EA553 Nature Pack Packaged 43 3109UMY74 Nova Straightner Private Label 44 3109EA918 Oil Private Label 45 3109UMY57 Organic Private Label 46 3109UMY19 Paraben Free Bulk     MAIN Formula and Macro Questions Formula and Macro Questions Data Visualization Hazr Sales Price 32,97 52,98 7,34 47,91 59,57 34,57 55,55 64,49 48,43 51,65 28,08 33,40 49,56 35,49 60,57 39,28 13,90 62,83 21,25 19,02 24,89 11,01 24,52 60,01 Wind Windo Region Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers AL roduct ID D E F G H 1 K A 1 Product ID 41 3109EA524 42 3109EA553 43 3109UMY74 44 3109EA918 45 3109UMY57 46 3109UMY19 47 3109EA228 48 3109EA269 49 3109UMY59 50 3109EA625 51 3109EA326 52 3109UMY16 53 3109EA555 54 3109UMY71 55 3109UMY62 56 3109UMY70 57 3109UMY17 58 3109EA536 59 3109EA911 60 3109UMY37 B Product Name Mousse Nature Pack Nova Straightner Oil Organic Paraben Free Pomade Room Freshener Root Pump Scissor Scrub Serum Shahnaz Protein Mask Skin Toner Texturizer Trimmer Unscented Volumizer Wahl Trimmer Water Spray Wax Product Type Packaged Packaged Private Label Private Label Private Label Bulk Bulk Private Label Private Label Bulk Private Label Private Label Bulk Bulk Packaged Packaged Bulk Bulk Private Label Packaged Packaged Sales Price 21,25 19,02 24,89 11,01 24,52 60,01 12,31 6,86 39,00 14,79 26,20 43,27 37,50 39,07 16,86 20,27 41,74 11,05 68,42 29,39 58,86 61 3109EA612 62 63 Wi 64 K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr AT D E F G H 1 K B Region ID 2 3 5 5 5 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 1 5 F  Customer Customer Group DA Depot DC EG IA DC DC IA IA WH DA WH Depot AK IA Depot IA DC Depot DA KA Depot Depot EG Depot MA EG DC 5 2 A 1 Customer 2 A1 3 Abba 4 ABC 5 Abr 6 Acar 7 Aceka 8 Active 9 Ada 10 Adallar 11 Adem 12 Adigzeller 13 Adria 14 Ada 15 Airpak 16 AK 17 Akabe 18 Akaln 19 Akar 20 Akay 21 Akbulut 22 Akdeniz 23 Akdin 24 Aker 25 Akif 6 3 3 7 3 7 WH MA 3 3 2 EG WH DA WH 3 DC EG 7 WH MA 7 DC MA 6 KA Depot 2 Depot DA 4 GA DC 5 Depot IA Formula and Macro Questions W Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Tapisi K 7   A a Birletir ve Ortala   600 CKIE 7 Y Biim Boyacs Pano A1 IdUIU afak nucre Biimlendirme Bicimlendir   Stilleri Stiller Hizalama Sayi Hcreler Yaz Tipi 1 for Customer A B D E F G H 1 J J K L Region ID 2 4 5 5 5 2 5 7   Customer Group Depot DA GA DC Depot IA IA DC IA WH DC DA IA DC MA DC EG Depot DA WH DC MA Depot IA DC KA GA Depot EG DC IA WH WH MA 3 2 7 1 Customer 23 Akdin 24 Aker 25 Akif 26 Aki 27 Akkurt 28 Akmer 29 Akmertas 30 Akport 31 Aksa 32 Aksel 33 Aktiford 34 Akturan 35 Akuapa 36 Akvet 37 Akyol 38 Akyrekler 39 Alfa 40 Alg 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen KI MAIN Hazr 5 6 4 3 5 7 6 KA WH 3 EG WH 5 IA Depot 6 DC KA 6 DC KA 3 DC EG 3 EG Depot Formula and Macro Questions Windo Window Customers Regions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 D E F G H 1 K L I Region ID 3 5 6 A 1 Customer 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen 47 Alpplast 48 Altek 49 Alternatif 50 Altin 51 Altinel 52 Altnta 53 Always 54 Ambiance 55 Ankamar 56 Anr 6 3 3 5 1 for Customer Customer Group EG WH IA Depot DC KA DC KA DC EG EG Depot IA Depot DC AK DC KA MA WH WH KA IA Depot MA WH 6 7 6 5 7 GA DC 4 2 3 6 6 6 57 Ant 58 Antik 59 Ardini 60 Ari 61 Armine 62 Art 63 Artem 64 AS DA DC EG Depot DC KA KA WH KA WH DC EG WH MA DA DC WHIA WH MA 3 7 2 5 7 Windows Windowsure Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products 7 5 7 5 1 1 6 2 4 7 1 64 AS 65 Asil 66 Asilzade 67 Aslanlar 68 Asya 69 Ataizi 70 Atila 71 Atlas 72 Atlyem 73 Ats 74 Autoprotect 75 Aydntepe 76 Baby 77 Bari 78 Bedesten 79 Bellona 80 Berr 81 Berrak 82 Beta 83 Beys 84 Bosart 85 BRN 86 Buka 87 Brosit WH MA Depot IA Depot MA IA DC AK DC AK DC WH KA Depot DA GA Depot DC MA AK DC AK Depot DC DA Depot AK WH EG GA Depot WH KA Depot IA DC DA EG DC Depot IA IA DC 1 2 1 3 4 6 5 2 3 5 5 5 WHIA 4 Depot GA Windows'u Windows uretki Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr 85 BRN 5 86 Buka 5 87 Brosit 4 7 4 5 IA DC WHIA Depot GA MA Depot Depot GA IA Depot IA DC WH EG Depot AK DC KA MA Depot MA DC 5 3 1 6 7 7 4 WH GA 88 By 89 Can 90 CCK 91 Cennet 92 Cihangir 93 Classi 94 Comfort 95 Country 96 Cyk 97 an 98 alkan 99 etmen 100 iek 101 imen 102 Doruk 103 Davenza 104 Deka 105 Detay 106 Dion 107 Dizayn 108 Doa 7 WH MA 5 6 7 6 7 IA DC KA Depot MA WH DC KA Depot MA GA DC DC KA Depot KA AK DC WHAK 4 6 6 1 Wind 1 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Region Hazr Pano Yaz Tipi Hizalama 15 Sayi Stiller Hcreler A1 for Customer B D E G H J K L Region ID 6 1 1 2 5 4 7 6 4 5 7 A 1 Customer 106 Dion 107 Dizayn 108 Doa 109 Dota 110 Dou 111 Duayen 112 Ecem 113 EFFE 114 Ekto 115 Elano 116 Elips 117 Elize 118 Elve 119 Engince 120 Enne 121 Erbil 122 ESEREV 123 Esste 124 Evim 125 Flash 126 FM 127 Forml 128 Fuga 129 Fze C Customer Group Depot KA AK DC WHAK DA Depot IA DC WH GA DC MA KA Depot Depot GA IA DC Depot MA GA DC KA DC GA WH DC EG DA Depot IA WH EG DC MA DC Depot MA Depot EG KA DC DA DC MA WH 4 6 4 3 2 5 3 3 7 7 3 6 2 7 Windov Windows Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Region ID Customer Group 6 KA DC 2 DA DC 7 MA WH 5 3 IA WH EG DC DC EG 3 2 DA DC 4 GA WH WHAK 1 AK DC 1 5 1 1 Customer 127 Forml 128 Fuga 129 Fze 130 Gala 131 Gallery 132 Gaziantepli 133 Gencay 134 Genkan 135 Geomekanik 136 Get 137 Giri 138 Gisan 139 Gmaks 140 Gold 141 Gkeler 142 Gktun 143 Gral 144 Gzde 145 Grb 146 Grup 147 Gler 148 Gleryz 149 Glah 150 Gnaydnlar KN MAIN Hazr 2 DCIA AK Depot DC DA DA WH DC EG 2 3 5 IA DC Depot IA 5 6 WH KA 6 DC KA 2 7 7 4 WH DA MA Depot Depot MA GA DC DA DC 2 Window Windows Customers Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer D E F G H K L 1 Customer Region ID 148 Gleryz 7 149 Glah 4 150 Gnaydinlar 2 151 Gndodu 4 152 Gnhanlar 6 153 Grlek 1 154 Grman 7 155 Grah 3 156 Gzel 6 157 Haidi 7 158 Hakan 7 159 Hakk 3 160 Hakmet 3 161 Hakzerler 1 162 Halaman 4 163 Hamann hellmann 6 164 Harman 2 165 Harmanc 2  166 Has 5 167 Hasel 1 168 Hat 2 169 Hellmann 7 170 Hevin 3 171 Hilal 5 C Customer Group Depot MA GA DC DA DC DC GA Depot KA AK Depot MA WH Depot EG DC KA MA Depot Depot MA EG WH Depot EG AK DC WH GA KA Depot WH DA DA DC IA Depot Depot AK WH DA WH MA EG WH IA WH Wind Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Regio A D E F G H M B Region ID 7 3 1 Customer 169 Hellmann 170 Hevin 171 Hilal 172 Hisar 173 Hmk 174 Horeka 5 7 4 Customer Group WH MA EG WH IA WH MA Depot DC GA MA DC 7 3 WH EG 6 Depot KA IA WH 5 2 175 Horoz 176 Hseyin 177 Ingbank 178 Irmak 179 Iglotek 180 ihlas 181 ikizler 182 ilke 183 imeks 4 DA WH GA DC DA WH WH MA 2 7 3 3 184 Img 6 3 2 185 inan 186 inan 187 inci 188 inter 189 Interrior 190 stanbul 191 istikbal 192 ibir 1 2 3 2 EG WH EG Depot WH KA EG Depot Depot DA AK DC DA DC Depot EG DC DA AK Depot WH KA 1 6 Windows'u B Windows u etkin Customers Regions K4 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr do kes Calibri 11 AN Metni kaydir Genel 1 Yaptr Birletir ve Ortala Ekle Sil 4,0 ,00 ,00 5,0   Biim Ea Kopyala Biim Boyacs Pano A1 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Hizalama Say Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B  Region ID 2 1 6 7 4 3 1 1 5 4 5 1 Customer 190 stanbul 191 stikbal 192 ibir 193 Just 194 Kadir 195 Kadri 196 Kalsan 197 Kalyon 198 Kamel 199 Ka met 200 Kapars 201 Kar 202 Karagn 203 Karahan 204 Karakter 205 Karat 206 Kardem 207 Kargili 208 Kavas 209 Kelebek 210 Keops 211 keyf 212 Kilim 213 Koala 1 Customer Group DC DA AK Depot WH KA Depot MA Depot GA EG WH AK Depot AK DC IA WH GA DC IA Depot AK WH Depot DA WH DA GA WH DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK 2 2 4 7 5 3 6 1 6 1 6 1 Windows Windows'un Customers Regions K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Calibri A A VY E' Metni kaydir Genel EH FH Yaptr T Birletir ve Ortala    , 0,00 ,00,0 Ekle Sil Y Y Ea Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Yaz Tipi Hizalama Sayi Hcr for Customer D E F G H 1 J K B Region ID 7 5 3 6 1 A 1 Customer 205 Karat 206 Kardem 207 Kargile 208 Kavas 209 Kelebek 210 Keops 211 Keyf 212 Kilim 213 Koala 214 Koray 215 Kozza 216 Kukla 6 1 6 1 1 6 Customer Group DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK AK DC WH KA EG WH Depot IA WH EG DC DA DC IA DC KA DC MA DC AK DC EG AK Depot DC DA WHAK 3 5 217 La 218 Lazzoni 3 219 Lenova 2 5 6 7 1 3 220 Leonart 221 Line 222 Linea 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge KI MAIN Hazr 1 2 1 4 4 WH GA Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Red Pano 15 Hizalama 5 Sayi Stiller Hcreler A1 D E F H 1 J L M 1 Customer 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge 229 Lutra Yaz Tipi for Customer B  Region ID Customer Group 1 DC AK 3 DC EG 1 AK Depot 2 DC DA 1 WHAK 4 WH GA 2 DA DC 1 Depot AK 5 IA WH 1 AK Depot 3 EG Depot 3 Depot EG 2 DA DC 3 EG WH 7 Depot MA 4 Depot GA 2 WH DA 230 Luxxa 231 Macitler 232 Marka 233 Mass 234 Maxx 235 Maya 236 Mazzini 237 MD 238 Merve 239 Mesa 4 GA DC 3 2 240 Messt 241 Metropool 242 MG 243 Millennium 244 Mirage 245 Monalisa 246 Montel 3 DC EG DC DA DC EG KA Depot DCIA 6 5 4 4 GA WH Windows'u Windows'unetki Customers Regions MAIN Hazr Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir Fat Birlestir ve Ortala 7   Biim Boyacisi 4,000 ,00  ,0 Ekle Koullu Tablo Olarak Hucre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Hizalama Sayi Hu Yaz Tipi fr Customer A1 A E F G H 1 J J K 1 Customer 244 Mirage 245 Monalisa 246 Montel 247 Mrs 248 Mustafa 249 Muzaffer 250 Mzf 251 NDesign 252 Neptun 253 Nero 254 Neva 255 Neveda 256 New 257 Newjoy 258 Nil 259 Nisa 260 Nurelik 261 Nans 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan B D Region ID Customer Group 6 KA Depot 5 DC IA 4 GA WH 4 GA DC 4 DC GA 1 AK DC 1 AK WH 6 KA Depot 7 MA DC 3 EG DC 2 DC DA 3 EG WH 6 KA Depot 3 Depot EG 5 IA WH 5 WHIA 7 MA WH 6 WH KA 5 IA DC 1 DC AK 7 Depot MA 1 DC AK 4 GA DC 3 EG Depot Formula and Macro Questions Data Visualization w wi Customers RO MAIN Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Pano Yaz Tipi Hizalama Sayi Stiller H A1 for Customer A B D E F G H 1 K Region ID 5 1 7 1 4 3 Customer Group IA DC DC AK Depot MA DC AK GA DC EG Depot GA WH DA Depot MA Depot EG DC 4 2 7 3 5 IA DC 5 1 Customer 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan 268 z 269 zgr 270 znil 271 ztrkler 272 Polatlar 273 Rada 274 Ranseyman 275 Ravhome 276 Ray 277 Recep 278 Reform 279 Rengarenk 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara MAIN Hazr 1 6 5 4 2 1 IA Depot AK WH KA DC IA DC WH GA WH DA AK WH WH DA GA WH IA DC EG DC MA WH Depot AK 2 4 5 3 7 1 Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Re Yaptr Birletir ve Ortala CD E Kopyala Biim Boyacisi Pano 15   4,0,00 60 ,0 Ekle Koullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Hizalama Sayi Yaz Tipi fr Customer A1 A D E F G H 1 j K B  Region ID 2 4 5 3 7 1 7 5 1 Customer 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara 286 Saray 287 Selim 288 Sembol 289 Serena 290 Sevil 291 Sinerji 292 Stella 293 Studio 294 Suite 295 anze 296 Tepe 297 Toprak 2 1 7 6 6 Customer Group WH DA GA WH IA DC EG DC MA WH Depot AK WH MA IA DC DC DA DC AK WH MA WH KA WH KA AK Depot Depot EG EG WH KA WH EG DC KA WH Depot GA Depot MA AK WH MA DC MA DC 1 3 3 6 3 298 Tpy 6 4 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 7 1 7 7 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Hazr Yaptr   a Birlestir ve Ortala    , 0,00 ,00 5,0 Ekle E Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Sil y Hizalama 15 Sayi Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 3 Customer Group EG WH KA WH EG DC 6 3 6 4 7 KA WH Depot GA Depot MA AK WH MA DC 1 7 7 MA DC 7 WH MA DC KA 6 3 1 Customer 295 anze 296 Tepe 297 Toprak 298 Toy 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 304 Turko 305 Tmlas 306 Uur 307 Ultra 308 Ulustrans 309 Umay 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay KM MAIN Hazr 1 5 4 5 1 3 EG DC DC AK IA Depot GA WH IA DC AK Depot WH EG DC KA WH KA EG DC DC KA DC AK DA WH 6 6 3 6 1 2 Wind Windo Customers Region Formula and Macro Questions x Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer A D E F H 1 J K L DC KA 1 Customer 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay 319 naldi 320 Unipack 321 niversal 322 ns 323 Vanessa 324 Vankim 325 Vardar 326 Vardarl 327 Vefa 328 Vemsan 329 Vera 330 Vetrina 331 Vetsan 332 Viens 333 Visys B Region ID Customer Group 5 IA DC 1 AK Depot 3 WH EG 6 6 WH KA 3 EG DC 6 DC KA 1 DC AK 2 DA WH 5 IA Depot 3 DC EG 7 Depot MA 2 WH DA 5 DCIA 7 MA WH 6 KA Depot 1 DC AK 3 EG WH 3 Depot EG 6 KA WH 5 IA Depot 6 Depot KA 3 EG Depot 4 WH GA Windo Window Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir a kopyala Biim Boyacisi Birletir ve Ortala Y   9 4,0 ,00 ,00 7,0 Ekle Sil Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Yaz Tipi 19 Hizalama Sayi Hcre A1 fx Customer A B D E F G H 1 L 1 Customer Region ID 6 3 4 3 1 5 331 Vetsan 332 Viens 333 Visys 334 Vivense 335 Vogue 336 Volpi 337 Wein 338 Weltew 339 Wood 340 Yaprak  341 Yasay 342 Yata 343 Yavuz Customer Group Depot KA EG Depot WH GA EG Depot AK Depot DCIA IA Depot DC AK DA Depot Depot KA DC GA IA WH 5 1 2 6 4 5 3 3 7 344 Yeni 345 Yldz 346 Yol 347 Yona WH EG DC EG MA DC DC MA DC AK DC EG 7 1 3 6 348 Ym 349 Yrkler 350 Yunus 351 Yurtii 352 Ycel 5 KA WH WHIA KA Depot MA DC 6 7 5 WHIA 353 Zebrano 354 Zevk Wit 1 AK WH KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Reg Hazr Pang 15 Hizalama 5 Sayi Stiller Hcr A1   D E F G H 1 J K 1 B  Region ID 3 Yaz Tipi for Customer Customer Group WH EG DC EG 3 7 MA DC 7 DC MA 1 3 1 Customer 343 Yavuz 344 Yeni 345 Yldz 346 Yol 347 Yona 348 Ym 349 Yrkler 350 Yunus 351 Yurtii 352 Ycel 353 Zebrano 354 Zevk 355 Zivella 356 Zwick 6 DC AK DC EG KA WH WHIA KA Depot MA DC 5 6 7 5 WHIA AK WH 1 3 3 EG DC WH EG 357 358 359 360 361 362 363 364 365 Wi 366 KM MAIN Formula and Macro Questions, Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr PE Dosya Giris Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm 1   Calibri 11 AA 3 Metni kaydir Genel D H H 0 Yaptr   Birletir ve Ortala kes Ea Kopyala Biim Boyacisi Pano A1  , 0,00 ,60 ,0 Ekle Sil Bicin Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Yaz Tipi Hizalama 154 Say 15 Hcreler fr Region ID C D E F G H 1 J J K L M A 1 Region ID 2 3 B Region Name 1 Akdeniz 2 Dou Anadolu 4 3 Ege 5 6 4 Gneydou Anadolu 5 Anadolu 6 Karadeniz DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 7 8 7 Marmara 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Window Windows Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara KM MAIN Hazr Branch Izmir Price Categories Products Customers H B D Aydn, ar 117203109 FOR EACH QUESTION INCLUDING MACROS, ASSIGN THE MACRO YOU WROTE TO THE YELLOW RECTANGLE SHAPE ABOVE THE QUESTION  WHEN THE SHAPE IS CLICKED, THE MACRO SHOULD CLEAR THE DATA FIRST (IF ANY, STARTING FROM THE 6th ROW) IN THE COLUMNS REGARDING THE QUESTION (COLUMNS A G FOR Q1, ONLY COLU QUESTION 1 (15 points) QUESTION 2 (5 points) QUESTION 3 (5 points) Using macro, copy the sales for each branch to the following rows and fill the branch info  Note that you should have 129 transactions in total  Using the relevant formulas and Product Descr , write down the product ID for each transaction  Note that the product ID is kept right before     in the description  Using VLOOKUP, product ID on the left and Products sheet, bring the additional price info of each product in each of the transactions  If you cannot solve the question using macros, you can manually copy the data here as this step affects the others  You will not get any points from this question in that case  Branch Month Day Quantity Year Customer Nam Product Descr  Product ID Product Name Product Type Sales Price Windows'u Etkinletir IMN H FOR Q2 etc ) QUESTION 4 (8 points) QUESTION 5 (10 points) QUESTION 6 (10 points) QUESTION 7 (5 points) QUESTION 8 (15 points) Using approximate VLOOKUP, product sales price on the left and Price Categories sheet, bring the Price Category info of each product (based on which interval its sales price falls into) in each of the transactions  Using macro, calculate the total amounts (quantity   sales price) for each transaction  Using VLOOKUPS, region ID of the customer in Customers Using VLOOKUP, Customer Name of the customer group includes  WH , it means the sheet and Regions sheet, bring the region name info of and Customers sheet, bring the customer corresponds to a warehouse  Using macro, find each customer in each of the transactions  customer group info of each out if the customers in each transaction corresponds to a customer in each of the warehouse  Write  YES  or  NO  based on the outcome  Hint  You may need a nested formula transactions  Copy and paste the results as a value within the macro  Price Category Total Amount Region Name Customer Group Is Warehouse  Windows'u Etkinletir Windowsu etkinlestirmek icin Avanlara aidi QUESTION 9 (12 points) It turns out that you had a problem with the deliveries on the following two dates  2019 08 11 and 2019 15 11 If the transaction date is any one of the above two, write  YES  to column Q  Write  NO  otherwise  Problem with the delivery  Windows'u Etkinletir Windows'i etkinlestirmek icin Avarlar'a gidin  Aydin agri 2 Microsoft Excel (run Etkinletirilemed Dosya Giris Ekle Sayfa Dzeni Formller Veri Gzden Geir Grnm A Otomatik Toplam HT H B Biim Dolgu 4,0 ,00 ,00 5,0 Ekle Sil Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller 22 Temizle Srala ve Filtre Bul ve Uygula Sec Dzenleme Hcreler 1 J   Kes Calibri 11 A A 2 Metni kaydir Genel Ekopyala Yaptr Biim Boyacs K T A ra Birletir ve Ortala    Pano Yaz Tipi Hizalama Say A1 fx Table 1  Total quantities sold per branch per year A B D E F G 1 Table 1  Total quantities sold per branch per year 2 YEAR 3 Branch 2015 2016 2017 2018 2019 2020 4 Istanbul 3140 2600 2700 1660 2600 4200 5 Izmir 1780 1920 3520 2720 2760 2680 6 Ankara 480 1600 1620 1060 300 780 7 PROBLEMS WITH THE VISUAL  8 9 9 YEARS 2015,2016,2017,2018,2019,2020 10 11 12 13 14 ALTERNATIVE VISUAL  15 16 4500 4000 3500 3000 2500 2000 1500 1000 500 Foto 17 Izmir Ankara Istanbul 18 19 2015 3140 2016 2600 2017 2700 2019 2600 20 2018 1660 1060 Istanbul Ankara 2020 4200 780 21 480 1600 1620 300 22 Izmir 1780 1920 3520 2720 2760 2680 23 24 Istanbul Ankara Izmir 25 Windows'u Etkinletir Windows'utetkintestirmek icin Avanlara aidin Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers III 0 Otomatik Toplam Calibri 11 2 Metni kaydir Genel Birletir ve Ortala    ,0,00 ,00 5,0 Ekle   Kes La Kopyala Yaptr Biim Boyacisi Pano J2 Sil 7 Biim Srala ve Fil Koullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Dolgu 2 Temizle   Uygula Yaz Tipi 15 Hizalama 51 Sayi Hcreler Dzenleme fo B D E F G H 1 16 17 A 2500 2000 1500 1000 500 Izmir Ankara Istanbul 18 19 2015 3140 2018 1660 2019 2600 20 Istanbul 2016 2600 1600 1920 2017 2700 1620 3520 2020 4200 780 21 Ankara 480 1060 300 22 Izmir 1780 2720 2760 2680 23 24 Istanbul Ankara izmir 25 26 27 28 QUESTION 10 (15 points) 29 30 31 POINT OUT THE PROBLEMS WITH THE CHART ABOVE  THEN, ADD A BETTER CHART TO THIS PAGE TO VISUALIZE TABLE 1, THAT ADDRESSES THE ISSUES YOU RAISED AND THAT TAKES  THE DO'S AND DONT'S OF DATA VISUALIZATION  INTO ACCOUNT  32 33 34 35 ALTHOUGH GENERATING THE ALTERNATIVE GRAPH HERE WITHIN EXCEL WOULD BE MORE CONVENIENT FOR YOU, YOU CAN GENERATE THE GRAPH SOMEWHERE ELSE (POWER BI etc ) AND PASTE IT HERE AS A PICTURE AS WELL  36 37 38 39 40 Windows'u Etkinletir Windows'u etkintestirmek icin Averlere gid Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir KI Hazr Price Categories Products Customers A B D K L M N O Month Year  Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 16 140 22 100 13 160 7 16 240 3 11 400 10 16 160 E F G H Customer Name Product Descr  2018 Sara 3109EA243 Face Puff 2018 Horeka 3109UMY79 Scrub 2016 Volpi 3109UMY77 Hair Spa 2020 zgr 3109UMY45 Mac Brush 2019 Adria 3109EA243 Organic 2017 Dou 3109UMY54 Wax 2015 Kamel 3109EA518 Pomade 2020 Grup 3109EA915 Lotion 2017 Hasel 3109UMY12 Wax 2017 Hamann hellm  3109EA119 Volumizer 2020 istanbul 3109EA376 Loreal Series 2015 Ambiance 3109EA329 Biotique Facial Kit 2015 Roni 3109UMY74 Leave in Conditioner 2020 Ozan 3109UMY53 Curl Enhancing 2015 Brosit 3109EA915 Unscented 2018 Evim 3109EA516 Hair Straightner 2019 Ycel 3109UMY55 Bleach Cream 2017 Altin 3109UMY38 Lacto Oil Balance 2015 Hat 3109UMY53 Hair Wax 2019 Dion 3109UMY55 Curl Enhancing 2018 Hisar 3109EA826 Nature Pack 2018 Horeka 3109UMY68 Water Spray 2018 Universal 3109UMY2 Loreal Series 2018 Gzel 3109EA913 Root Pump 1 1 5 240 8 260 1 5 6 400 2 2 280 5 2 100 6 5 100 5 5 180 26 340 Boca 19 200 9 5 120 6 3 260 13 360 1 13 120 Windows'u Etkinletir Windowslettintestine A J K L M 25 26 27 28 29 30 31 32 33 34 35 36 37 B C D E F G H 1 1 13 120 2018 Gzel 3109EA913 Root Pump 10 14 120 2019 Keyf 3109EA826 Mac Brush 11 11 140 2017 CCK 3109EA617 Conditioning Mask 2 28 160 2020 Yeni 3109EA562 Face Pack 6 28 280 2015 Inter 3109UMY68 Scrub 3 1 320 2020 Wein 3109UMY59 Color Extending 10 20 400 2017 Linea 3109UMY49 Organic 4 9 9 280 2020 Sahne 3109EA521 Serum 5 3 140 2015 Gndodu 3109UMY49 Mousse 12 23 360 2017 Dou 3109EA956 Volumizer 5 17 360 2018 Gaziantepli 3109UMY54 Scrub 9 27 120 2017 LOTS 3109EA765 Gatsby Wax 11 7 380 2015 Tepe 3109EA562 Nature Pack 1 280 2017 Horeka 3109UMY38 Comb 12 24 320 2017 Wein 3109UMY60 Organic 4 23 280 2016 Altek 3109EA243 Facial Pack 10 14 380 2017 Akbulut 3109EA243 Scrub 6 8 360 2015 Hilal 3109UMY79 Massage Cream 3 16 400 2020 Ataizi 3109EA663 Room Freshener 11 23 320 2016 Tmlas 3109EA119 Leave in Conditioner 12 23 160 2020 CCK 3109UMY79 Feature 12 20 300 2020 Cennet 3109UMY55 Paraben Free 5 5 4 400 2019 Gallery 3109UMY4 Facial Pack 3 10 120 2016 Vetrina 3109EA765 Conditioning Mask 11 16 360 2019 Unotek 3109EA139 Mac Brush Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories 38 4 39 40 41 42 43 44 45 46 47 48 49 Windows Windows Regions KI MAIN Products Customers   IVIOIILIT A B D E 1 J K L M 49 11 16 360 2 360 50 51 2 3 9 16 140 16 140 12 20 400 52 53 54 55 4 26 280 400 4 3 56 6 26 400 F G H 3109EA139 Mac Brush 3109UMY74 Hair Comb 3109EA329 Water Spray 3109EA956 Lotus Herbal 3109UMY59 Nova Straightner 3109EA444 Paraben Free 3109EA518 Texturizer 3109UMY68 Shahnaz Protein Mask 3109UMY69 Root Pump 3109UMY59 Hair Wax 3109UMY54 Oil 3109UMY45 Gel 3109UMY64 Comb 3109UMY52 Unscented 3109UMY49 Hair Wax 3109UMY23 Hair Wax 3109UMY24 Leave in Conditioner 57 10 12 2019 Unotek 2019 Hakzerler 2017 Zivella 2016 Recep 2015 Yona 2017 Mrs 2017 Armine 2015 Horeka 2018 Iglotek 2017 Art 2018 Akaln 2019 Selim 2016 Asil 2020 Mustafa 2019 ilke 2019 La 2019 Fze 100 8 120 58 59 1 10 9 2 100 60 2 320 61 11 23 100 3 22 320 62 63 14 260 2 5 64 18 140 65 10 23 360 66 67 68 69 70 71 72 73 KI Window Windows Regions MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers A B 1 J K L M Month Day 2 Quantity 15 25 17 6 8 1 9 27 6 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMN ADDING A NEW CALCULATED COLUMNE ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLU THOUGH 8 3 1 13 8 6 9 4 28 11 24 2020 Fuga 9 8 1 5 D E F G H Year Customer Name Product Descr  100 2015 Saltolu 3109EA554 Face Capsule 340 2019 Messt 3109EA980 Nature Pack 120 2017 Ecem 3109UMY19 Alcohol Free 300 2019 Vankim 3109UMY55 Biotique Ayurveda 180 2017 Atila 3109EA770 Paraben Free 400 2018 Can 3109UMY71 Hair Wax 260 2016 Elize 3109UMY33 Nova Straightner 380 2020 Evim 3109EA312 Bleach Cream 240 2017 Ataizi 3109EA911 Massage Cream 360 2020 Tpy 3109EA956 Nova Straightner 240 3109EA966 Color Extending 200 2018 Gencay 3109UMY3 Hair Straightner 180 2017 ibir 3109EA444 Hair Color 360 2015 Line 3109EA437 Anti Frizz 140 2018 Tramer 3109EA424 Gel 280 2018 Wein 3109UMY71 Color Extending 200 2016 Adria 3109EA842 Clay 400 2016 Altnta 3109EA312  Hair Straightner 260 2016 Elano 3109EA163 Face Puff 340 2018 stikbal 3109EA554 Curling Tong 120 2015 Akmerta 3109EA424 Mousse 320 2018 Macitler 3109UMY26 Color Extending 200 2018 Ekto 3109EA872 Scrub 320 2019 Davenza 3109EA 749 Wahl Trimmer Data Visualization Branch Istanbul Branch Ankara Branch Izmir 17 9 8 1 28 12 5 1 29 9 1 12 3 29 4 6 8 2 10 3 10 12 25 Windows'u Windows'uneiki Products Customers Regions            MAIN Formula and Macro Questions Price Categories azu A1 for Month B C D H 1 6  7 28 5 29 12 1 9 12 9 1 140 280 200 400 260 340 120 320 3 29 1 22 4 6 2 8 E 2018 Tramer 2018 Wein 2016 Adria 2016 Altnta 2016 Elano 2018 istikbal 2015 Akmerta 2018 Macitler 2018 Ekto 2019 Davenza 2017 A1 2020 Halaman 2017 Linea 2019 Visys 2015 Esste F G 3109EA424 Gel 3109UMY71 Color Extending 3109EA842 Clay 3109EA312 Hair Straightner 3109EA163 Face Puff 3109EA554 Curling Tong 3109EA424 Mousse 3109UMY26 Color Extending 3109EA872 Scrub 3109EA 749 Wahl Trimmer 3109EA813 Loreal Series 3109UMY36 Lacto Oil Balance 3109UMY36 Bleach Cream 3109EA437 Hair Wax 3109UMY1 Bleach Cream 10 3 10 200 23  4  5 26 27 12 25 320 7 21 360 7 12 320 00 10 0 0 0 0 0 400 19 1 25 260 12 26 220 1 2 3 24 5 6 7 8 59 20   MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Month Quantity 21 Day 2 7 1 8 20 5 16 10 5 DO NOT MAKE ANY (CHANGING THE ORDER ADDING A NEW CALCULA ON THIS P YOU CAN CHANGE THE WID THOUG 9 21 8 11 8 19 4 6 10 8 12 4 1 30 Year Customer Name Product Descr  280 2020 ABC 3109EA479 Gel 160 2016 Horoz 3109UMY35 Gel 220 2016 Akmer 3109EA854 Hair Spray 400 2016 Grup 3109UMY76 Leave in Conditioner 220 2018 Volpi 3109EA445 Wahl Trimmer 140 2019 zgr 3109EA760 Loreal Series 320 2018 Dion 3109UMY35 Face Wash 240 2018 Trusa 3109UMY53 Water Spray 400 2018 Gkeler 3109EA864 Biotique Ayurveda 180 2020 Uur 3109EA423 Scrub 300 2015 Elize 3109UMY62 Makeup Brush 240 2016 New 3109EA549 Pomade 300 2016 Zebrano 3109UMY9 Root Pump 360 2019 Engince 3109UMY77 Root Pump 340 2015 imeks 3109UMY39 Bleach Cream 240 2019 Bedesten 3109EA333 Oil 160 2019 Mzf 3109EA955 Gatsby Wax 320 2018 Gktun 3109UMY53 Face Wash 240 2018 Art 3109UMY13 Loreal Series 300 2020 FM 3109EA760 Comb 260 2017 Cennet 3109EA854 Mousse 160 2017 Horoz 3109EA167 Gatsby Wax 360 2018 Vemsan 3109EA41 Hair Wax 180 2018 Zebrano 3109EA857 Curling Tong     Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 22 11 26 11 29 1 8 1 30 12 20 9 14 12 14 2 27 5 4 28 11 6 13 Formula and Macro Questions Price Categories Products MAIN azir Customer 6 13 11 14 9 18 8 8 11 26 12 12 7 10 7 17 11 1 8 20 2 13 12 12 10 13 180 2018 Zebrano 3109EA857 Curling Tong 240 2015 Aydntepe 3109EA864 Mac Brush 380 2020 Doa 3109UMY2 Face Pack 180 2016 Mustafa 3109EA76 Clay 220 2019 Tmlas 3109EA459 Nova Straightner 320 2016 Adigzeller 3109EA854 Biotique Ayurveda 400 2019 Gzde 3109EA969 Curling Tong 380 2015 Akuapa 3109EA728 Water Spray 140 2016 Ozan 3109UMY68 Lotion 400 2020 Karahan 3109EA543 Gel 160 2015 Davenza 3109EA445 Heat Protectant 180 2015 Kadir 3109UMY68 Facial Pack 400 2016 Gkeler 3109EA115 Hair Spray 280 2015 Sara 3109EA938 Makeup Brush 220 2018 Asilzade 3109UMY62 Root Pump 120 2018 Keyf 3109EA851 Face Pack 320 2016 Gold 3109UMY76 Loreal Series 360 2015 znil 3109EA445 Feature 400 2018 anze 3109UMY76 Hair Color 240 2019 an 3109EA857 Comb 340 2017 imeks 3109EA173 Unscented 300 2017 Akvet 3109EA173 Mac Brush 280 2019 Horeka 3109UMY62 Blossom Face Wash 280 2020 Horeka 3109EA479 Face Puff 320 2020 Gallery 3109EA41 Wahl Trimmer   Data Visualization Branch Istanbul Branch Ankara Branch Izmir 7 13 3 5 11 30 18 7 8 17 9 9 12 9 11 10 4 11 12 21 3 26 7 21 Wing Windo Region MAIN Formula and Macro Questions Price Categories Products Customers 11 30 120 7 18 320 8 17 360 9 9 400 12 9 240 11 10 340 4 11 300 12 21 280 2018 Keyf 2016 Gold 2015 znil 2018 anze 2019 an 2017 imeks 2017 Akvet 2019 Horeka 2020 Horeka 2020 Gallery 2018 Aker 2017 Atila 2020 Merve 2015 Zevk 2015 Baby 3109EA851 Face Pack 3109UMY76 Loreal Series 3109EA445 Feature 3109UMY76 Hair Color 3109EA857 Comb 3109EA173 Unscented 3109EA173 Mac Brush 3109UMY62 Blossom Face Wash 3109EA479 Face Puff 3109EA41 Wahl Trimmer 3109UMY62 Hair Comb 3109UMY63 Unscented 3109UMY8 Nova Straightner 3109UMY21 Texturizer 3109EA760 Nova Straightner 3 26 280 7 21 320 6 22 200 7 24 20 5 11 9 240 320 200 320 30 27 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Custom Hizalama Sayi Stiller Hcrel E F G H 1 J K L M N o Pano Yaz Tipi A1 for Price A B D 1 Price 2 Lower Bound Upper Bound Category 3 0,00 17,99 Basic 4 18,00 59,99 Premium 5 60,00 140,00 Deluxe 6 7 8 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 9 10 11 12 13 14 15 16 17 18 19 20 21 E F G H 1 K L D Sales Price 57,89 53,70 39,83 20,91 64,78 56,19 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 10,00 A Product ID 2  3109UMY49 3109UMY23 3109EA39 3109EA476 3109UMY56 3109UMY2 3109EA677 3109UMY33 0 3109EA964 1 3109EA33 2 3109EA835 3 3109UMY52 4 3109EA538 5 3109UMY73 6 3109EA539 7 3109EA347 8 3109UMY21 9 3109UMY15 LO 3109EA329 1 3109UMY44 2 3109EA854 3 3109EA545 4 3109UMY8 5 3109UMY79 MAIN B Product Name Alcohol Free Anti Frizz Biotique Ayurveda Biotique Facial Kit Bleach Cream Blossom Face Wash Clay Color Extending Comb Conditioning Mask Curl Enhancing Curling Tong Dry Shampoo Face Capsule Face Pack Face Puff Face Wash Facial Pack Feature Foam Gatsby Wax Gel Hair Caps Hair Color Formula and Macro Questions c Product Type Bulk Private Label Private Label Bulk Bulk Bulk Bulk Packaged Private Label Packaged Packaged Bulk Private Label Packaged Private Label Packaged Packaged Private Label Packaged Bulk Bulk Bulk Private Label Bulk Data Visualization 6,78 28,27 9,66 44,33 62,44 49,30 65,43 62,78 69,16 50,02 13,69 52,78 22,64 53,41 32,97 52,98 7,34 Branch Istanbul Windo Windows Customers Regions Branch Ankara Branch Izmir Price Categories Products Hazr D E F G H 1 J L A1 fx Product ID A B C 1 Product ID Product Name Product Type 23 3109EA545 Gel Bulk 24 3109UMY8 Hair Caps Private Label 25 3109UMY79 Hair Color Bulk 26 3109UMY6 Hair Comb Packaged 27 3109EA272 Hair Gel Packaged 28 3109EA 31 Hair Spa Bulk 29 3109UMY13 Hair Spray Private Label 30 3109UMY80 Hair Straightner Packaged 31 3109EA560 Hair Wax Bulk 32 3109UMY66 Heat Protectant Private Label 33 3109EA542 Lacto Oil Balance Private Label 34 3109UMY63 Leave in Conditioner Private Label 35 3109UMY68 Loreal Series Private Label 36 3109UMY65 Lotion Private Label 37 3109EA 34 Lotus Herbal Private Label 38 3109EA667 Mac Brush Private Label 39 3109EA 743 Makeup Brush Bulk 40 3109UMY51 Massage Cream Private Label 41 3109EA524 Mousse Packaged 42 3109EA553 Nature Pack Packaged 43 3109UMY74 Nova Straightner Private Label 44 3109EA918 Oil Private Label 45 3109UMY57 Organic Private Label 46 3109UMY19 Paraben Free Bulk     MAIN Formula and Macro Questions Formula and Macro Questions Data Visualization Hazr Sales Price 32,97 52,98 7,34 47,91 59,57 34,57 55,55 64,49 48,43 51,65 28,08 33,40 49,56 35,49 60,57 39,28 13,90 62,83 21,25 19,02 24,89 11,01 24,52 60,01 Wind Windo Region Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers AL roduct ID D E F G H 1 K A 1 Product ID 41 3109EA524 42 3109EA553 43 3109UMY74 44 3109EA918 45 3109UMY57 46 3109UMY19 47 3109EA228 48 3109EA269 49 3109UMY59 50 3109EA625 51 3109EA326 52 3109UMY16 53 3109EA555 54 3109UMY71 55 3109UMY62 56 3109UMY70 57 3109UMY17 58 3109EA536 59 3109EA911 60 3109UMY37 B Product Name Mousse Nature Pack Nova Straightner Oil Organic Paraben Free Pomade Room Freshener Root Pump Scissor Scrub Serum Shahnaz Protein Mask Skin Toner Texturizer Trimmer Unscented Volumizer Wahl Trimmer Water Spray Wax Product Type Packaged Packaged Private Label Private Label Private Label Bulk Bulk Private Label Private Label Bulk Private Label Private Label Bulk Bulk Packaged Packaged Bulk Bulk Private Label Packaged Packaged Sales Price 21,25 19,02 24,89 11,01 24,52 60,01 12,31 6,86 39,00 14,79 26,20 43,27 37,50 39,07 16,86 20,27 41,74 11,05 68,42 29,39 58,86 61 3109EA612 62 63 Wi 64 K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Rec Hazr AT D E F G H 1 K B Region ID 2 3 5 5 5 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC ) ON THIS PAGE  YOU CAN CHANGE THE WIDTH OF THE COLUMNS THOUGH 2 1 5 F  Customer Customer Group DA Depot DC EG IA DC DC IA IA WH DA WH Depot AK IA Depot IA DC Depot DA KA Depot Depot EG Depot MA EG DC 5 2 A 1 Customer 2 A1 3 Abba 4 ABC 5 Abr 6 Acar 7 Aceka 8 Active 9 Ada 10 Adallar 11 Adem 12 Adigzeller 13 Adria 14 Ada 15 Airpak 16 AK 17 Akabe 18 Akaln 19 Akar 20 Akay 21 Akbulut 22 Akdeniz 23 Akdin 24 Aker 25 Akif 6 3 3 7 3 7 WH MA 3 3 2 EG WH DA WH 3 DC EG 7 WH MA 7 DC MA 6 KA Depot 2 Depot DA 4 GA DC 5 Depot IA Formula and Macro Questions W Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Tapisi K 7   A a Birletir ve Ortala   600 CKIE 7 Y Biim Boyacs Pano A1 IdUIU afak nucre Biimlendirme Bicimlendir   Stilleri Stiller Hizalama Sayi Hcreler Yaz Tipi 1 for Customer A B D E F G H 1 J J K L Region ID 2 4 5 5 5 2 5 7   Customer Group Depot DA GA DC Depot IA IA DC IA WH DC DA IA DC MA DC EG Depot DA WH DC MA Depot IA DC KA GA Depot EG DC IA WH WH MA 3 2 7 1 Customer 23 Akdin 24 Aker 25 Akif 26 Aki 27 Akkurt 28 Akmer 29 Akmertas 30 Akport 31 Aksa 32 Aksel 33 Aktiford 34 Akturan 35 Akuapa 36 Akvet 37 Akyol 38 Akyrekler 39 Alfa 40 Alg 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen KI MAIN Hazr 5 6 4 3 5 7 6 KA WH 3 EG WH 5 IA Depot 6 DC KA 6 DC KA 3 DC EG 3 EG Depot Formula and Macro Questions Windo Window Customers Regions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 D E F G H 1 K L I Region ID 3 5 6 A 1 Customer 41 Aliriza 42 Alkom 43 Alkor 44 Alna 45 Alp 46 Alperen 47 Alpplast 48 Altek 49 Alternatif 50 Altin 51 Altinel 52 Altnta 53 Always 54 Ambiance 55 Ankamar 56 Anr 6 3 3 5 1 for Customer Customer Group EG WH IA Depot DC KA DC KA DC EG EG Depot IA Depot DC AK DC KA MA WH WH KA IA Depot MA WH 6 7 6 5 7 GA DC 4 2 3 6 6 6 57 Ant 58 Antik 59 Ardini 60 Ari 61 Armine 62 Art 63 Artem 64 AS DA DC EG Depot DC KA KA WH KA WH DC EG WH MA DA DC WHIA WH MA 3 7 2 5 7 Windows Windowsure Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products 7 5 7 5 1 1 6 2 4 7 1 64 AS 65 Asil 66 Asilzade 67 Aslanlar 68 Asya 69 Ataizi 70 Atila 71 Atlas 72 Atlyem 73 Ats 74 Autoprotect 75 Aydntepe 76 Baby 77 Bari 78 Bedesten 79 Bellona 80 Berr 81 Berrak 82 Beta 83 Beys 84 Bosart 85 BRN 86 Buka 87 Brosit WH MA Depot IA Depot MA IA DC AK DC AK DC WH KA Depot DA GA Depot DC MA AK DC AK Depot DC DA Depot AK WH EG GA Depot WH KA Depot IA DC DA EG DC Depot IA IA DC 1 2 1 3 4 6 5 2 3 5 5 5 WHIA 4 Depot GA Windows'u Windows uretki Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr 85 BRN 5 86 Buka 5 87 Brosit 4 7 4 5 IA DC WHIA Depot GA MA Depot Depot GA IA Depot IA DC WH EG Depot AK DC KA MA Depot MA DC 5 3 1 6 7 7 4 WH GA 88 By 89 Can 90 CCK 91 Cennet 92 Cihangir 93 Classi 94 Comfort 95 Country 96 Cyk 97 an 98 alkan 99 etmen 100 iek 101 imen 102 Doruk 103 Davenza 104 Deka 105 Detay 106 Dion 107 Dizayn 108 Doa 7 WH MA 5 6 7 6 7 IA DC KA Depot MA WH DC KA Depot MA GA DC DC KA Depot KA AK DC WHAK 4 6 6 1 Wind 1 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Region Hazr Pano Yaz Tipi Hizalama 15 Sayi Stiller Hcreler A1 for Customer B D E G H J K L Region ID 6 1 1 2 5 4 7 6 4 5 7 A 1 Customer 106 Dion 107 Dizayn 108 Doa 109 Dota 110 Dou 111 Duayen 112 Ecem 113 EFFE 114 Ekto 115 Elano 116 Elips 117 Elize 118 Elve 119 Engince 120 Enne 121 Erbil 122 ESEREV 123 Esste 124 Evim 125 Flash 126 FM 127 Forml 128 Fuga 129 Fze C Customer Group Depot KA AK DC WHAK DA Depot IA DC WH GA DC MA KA Depot Depot GA IA DC Depot MA GA DC KA DC GA WH DC EG DA Depot IA WH EG DC MA DC Depot MA Depot EG KA DC DA DC MA WH 4 6 4 3 2 5 3 3 7 7 3 6 2 7 Windov Windows Customers Regions KI MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Region ID Customer Group 6 KA DC 2 DA DC 7 MA WH 5 3 IA WH EG DC DC EG 3 2 DA DC 4 GA WH WHAK 1 AK DC 1 5 1 1 Customer 127 Forml 128 Fuga 129 Fze 130 Gala 131 Gallery 132 Gaziantepli 133 Gencay 134 Genkan 135 Geomekanik 136 Get 137 Giri 138 Gisan 139 Gmaks 140 Gold 141 Gkeler 142 Gktun 143 Gral 144 Gzde 145 Grb 146 Grup 147 Gler 148 Gleryz 149 Glah 150 Gnaydnlar KN MAIN Hazr 2 DCIA AK Depot DC DA DA WH DC EG 2 3 5 IA DC Depot IA 5 6 WH KA 6 DC KA 2 7 7 4 WH DA MA Depot Depot MA GA DC DA DC 2 Window Windows Customers Regions Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer D E F G H K L 1 Customer Region ID 148 Gleryz 7 149 Glah 4 150 Gnaydinlar 2 151 Gndodu 4 152 Gnhanlar 6 153 Grlek 1 154 Grman 7 155 Grah 3 156 Gzel 6 157 Haidi 7 158 Hakan 7 159 Hakk 3 160 Hakmet 3 161 Hakzerler 1 162 Halaman 4 163 Hamann hellmann 6 164 Harman 2 165 Harmanc 2  166 Has 5 167 Hasel 1 168 Hat 2 169 Hellmann 7 170 Hevin 3 171 Hilal 5 C Customer Group Depot MA GA DC DA DC DC GA Depot KA AK Depot MA WH Depot EG DC KA MA Depot Depot MA EG WH Depot EG AK DC WH GA KA Depot WH DA DA DC IA Depot Depot AK WH DA WH MA EG WH IA WH Wind Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products K MAIN Hazr Customers Regio A D E F G H M B Region ID 7 3 1 Customer 169 Hellmann 170 Hevin 171 Hilal 172 Hisar 173 Hmk 174 Horeka 5 7 4 Customer Group WH MA EG WH IA WH MA Depot DC GA MA DC 7 3 WH EG 6 Depot KA IA WH 5 2 175 Horoz 176 Hseyin 177 Ingbank 178 Irmak 179 Iglotek 180 ihlas 181 ikizler 182 ilke 183 imeks 4 DA WH GA DC DA WH WH MA 2 7 3 3 184 Img 6 3 2 185 inan 186 inan 187 inci 188 inter 189 Interrior 190 stanbul 191 istikbal 192 ibir 1 2 3 2 EG WH EG Depot WH KA EG Depot Depot DA AK DC DA DC Depot EG DC DA AK Depot WH KA 1 6 Windows'u B Windows u etkin Customers Regions K4 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr do kes Calibri 11 AN Metni kaydir Genel 1 Yaptr Birletir ve Ortala Ekle Sil 4,0 ,00 ,00 5,0   Biim Ea Kopyala Biim Boyacs Pano A1 Koullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Hizalama Say Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B  Region ID 2 1 6 7 4 3 1 1 5 4 5 1 Customer 190 stanbul 191 stikbal 192 ibir 193 Just 194 Kadir 195 Kadri 196 Kalsan 197 Kalyon 198 Kamel 199 Ka met 200 Kapars 201 Kar 202 Karagn 203 Karahan 204 Karakter 205 Karat 206 Kardem 207 Kargili 208 Kavas 209 Kelebek 210 Keops 211 keyf 212 Kilim 213 Koala 1 Customer Group DC DA AK Depot WH KA Depot MA Depot GA EG WH AK Depot AK DC IA WH GA DC IA Depot AK WH Depot DA WH DA GA WH DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK 2 2 4 7 5 3 6 1 6 1 6 1 Windows Windows'un Customers Regions K MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Calibri A A VY E' Metni kaydir Genel EH FH Yaptr T Birletir ve Ortala    , 0,00 ,00,0 Ekle Sil Y Y Ea Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Yaz Tipi Hizalama Sayi Hcr for Customer D E F G H 1 J K B Region ID 7 5 3 6 1 A 1 Customer 205 Karat 206 Kardem 207 Kargile 208 Kavas 209 Kelebek 210 Keops 211 Keyf 212 Kilim 213 Koala 214 Koray 215 Kozza 216 Kukla 6 1 6 1 1 6 Customer Group DC MA Depot IA EG DC KA WH Depot AK WH KA AK Depot DC KA WHAK AK DC WH KA EG WH Depot IA WH EG DC DA DC IA DC KA DC MA DC AK DC EG AK Depot DC DA WHAK 3 5 217 La 218 Lazzoni 3 219 Lenova 2 5 6 7 1 3 220 Leonart 221 Line 222 Linea 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge KI MAIN Hazr 1 2 1 4 4 WH GA Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Red Pano 15 Hizalama 5 Sayi Stiller Hcreler A1 D E F H 1 J L M 1 Customer 223 Liness 224 Litani 225 Lizbon 226 Loca 227 LOTS 228 Lounge 229 Lutra Yaz Tipi for Customer B  Region ID Customer Group 1 DC AK 3 DC EG 1 AK Depot 2 DC DA 1 WHAK 4 WH GA 2 DA DC 1 Depot AK 5 IA WH 1 AK Depot 3 EG Depot 3 Depot EG 2 DA DC 3 EG WH 7 Depot MA 4 Depot GA 2 WH DA 230 Luxxa 231 Macitler 232 Marka 233 Mass 234 Maxx 235 Maya 236 Mazzini 237 MD 238 Merve 239 Mesa 4 GA DC 3 2 240 Messt 241 Metropool 242 MG 243 Millennium 244 Mirage 245 Monalisa 246 Montel 3 DC EG DC DA DC EG KA Depot DCIA 6 5 4 4 GA WH Windows'u Windows'unetki Customers Regions MAIN Hazr Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Yapistir Fat Birlestir ve Ortala 7   Biim Boyacisi 4,000 ,00  ,0 Ekle Koullu Tablo Olarak Hucre Biimlendirme Biimlendir Stilleri Stiller Pano 15 Hizalama Sayi Hu Yaz Tipi fr Customer A1 A E F G H 1 J J K 1 Customer 244 Mirage 245 Monalisa 246 Montel 247 Mrs 248 Mustafa 249 Muzaffer 250 Mzf 251 NDesign 252 Neptun 253 Nero 254 Neva 255 Neveda 256 New 257 Newjoy 258 Nil 259 Nisa 260 Nurelik 261 Nans 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan B D Region ID Customer Group 6 KA Depot 5 DC IA 4 GA WH 4 GA DC 4 DC GA 1 AK DC 1 AK WH 6 KA Depot 7 MA DC 3 EG DC 2 DC DA 3 EG WH 6 KA Depot 3 Depot EG 5 IA WH 5 WHIA 7 MA WH 6 WH KA 5 IA DC 1 DC AK 7 Depot MA 1 DC AK 4 GA DC 3 EG Depot Formula and Macro Questions Data Visualization w wi Customers RO MAIN Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Hazr Pano Yaz Tipi Hizalama Sayi Stiller H A1 for Customer A B D E F G H 1 K Region ID 5 1 7 1 4 3 Customer Group IA DC DC AK Depot MA DC AK GA DC EG Depot GA WH DA Depot MA Depot EG DC 4 2 7 3 5 IA DC 5 1 Customer 262 Ocak 263 Odak 264 Odam 265 Oggi 266 Orta 267 Ozan 268 z 269 zgr 270 znil 271 ztrkler 272 Polatlar 273 Rada 274 Ranseyman 275 Ravhome 276 Ray 277 Recep 278 Reform 279 Rengarenk 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara MAIN Hazr 1 6 5 4 2 1 IA Depot AK WH KA DC IA DC WH GA WH DA AK WH WH DA GA WH IA DC EG DC MA WH Depot AK 2 4 5 3 7 1 Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Re Yaptr Birletir ve Ortala CD E Kopyala Biim Boyacisi Pano 15   4,0,00 60 ,0 Ekle Koullu Tablo Olarak Hcre Biimlendirme Biimlendir   Stilleri Stiller Hizalama Sayi Yaz Tipi fr Customer A1 A D E F G H 1 j K B  Region ID 2 4 5 3 7 1 7 5 1 Customer 280 Rinaldi 281 Roni 282 Sahne 283 SALL 284 Saltolu 285 Sara 286 Saray 287 Selim 288 Sembol 289 Serena 290 Sevil 291 Sinerji 292 Stella 293 Studio 294 Suite 295 anze 296 Tepe 297 Toprak 2 1 7 6 6 Customer Group WH DA GA WH IA DC EG DC MA WH Depot AK WH MA IA DC DC DA DC AK WH MA WH KA WH KA AK Depot Depot EG EG WH KA WH EG DC KA WH Depot GA Depot MA AK WH MA DC MA DC 1 3 3 6 3 298 Tpy 6 4 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 7 1 7 7 MAIN Formula and Macro Questions Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products Customers Hazr Yaptr   a Birlestir ve Ortala    , 0,00 ,00 5,0 Ekle E Kopyala Biim Boyacs Pano A1 Kosullu Tablo Olarak Hcre Biimlendirme Biimlendir Stilleri Stiller Sil y Hizalama 15 Sayi Hcreler Yaz Tipi for Customer A D E F G H 1 J K L B Region ID 3 Customer Group EG WH KA WH EG DC 6 3 6 4 7 KA WH Depot GA Depot MA AK WH MA DC 1 7 7 MA DC 7 WH MA DC KA 6 3 1 Customer 295 anze 296 Tepe 297 Toprak 298 Toy 299 Tramer 300 Trusa 301 Truva 302 TS 303 Tuna 304 Turko 305 Tmlas 306 Uur 307 Ultra 308 Ulustrans 309 Umay 310 Universal 311 Unotek 312 Uras 313 Urgan 314 Urhan 315 Urkaya 316 Uysal 317 Uzakdou 318 Uzay KM MAIN Hazr 1 5 4 5 1 3 EG DC DC AK IA Depot GA WH IA DC AK Depot WH EG DC KA WH KA EG DC DC KA DC AK DA WH 6 6 3 6 1 2 Wind Windo Customers Region Formula and Macro Questions x Data Visualization Branch Istanbul Branch Ankara Branch Izmir Price Categories Products A1 for Customer A D E F H 1 J K L DC KA 1 Custo

Accepted Answer

The Answer is in the image, click to view ...

Question

A B D K L M N O Month Year |Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

International Baccalaureate Computer Science HL And SL Option A Databases Part I Basic Concepts

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question