Spreadsheet: 668173d1584668115-advanced-sumifs-for-dashboard-building-slicer-replication-help-me-for-covid-immunity
Sheet: Datos

 | [NAME]
 | Ocasiones: datos validados
 |  | Input
 | 1. Datos
 | Year | Liquid | Variable | Occasion | Total | OFF Premise | ON Premise | Female | Male | LDA-24 | 25-34 | 35-44 | 45-54 | 55+ | High | Medium - High | Medium - Low | Low | Female | LDA-24 | Female | 25-34 | Female | 35-44 | Female | 45-54 | Male | LDA-24 | Male | 25-34 | Male | 35-44 | Male | 45-54 | Female | 55+ | Male | 55+ | Lima/Callao | Arequipa | Huancayo | Huanuco | Huaraz | Ica | Iquitos | Piura | Pucallpa | Puno/Juliaca | Tacna | Tarapoto | Trujillo | Ayacucho | [NAME] | Chimbote | Cusco | Grand Total
 | 2020 | Beer | k hL | Party | 6167.446680708698 | 4110.826721140036 | 2056.619959568663 | 2380.155771216201 | 3787.290909492501 | 1023.187474625928 | 1819.769304521262 | 1716.310711256193 | 1608.17919030532 | 0 | 1562.213014332392 | 1533.799193742741 | 2019.367766915313 | 1052.066705718253 | 356.7236748148 | 581.7153364380999 | 670.8420345622 | 770.8747254011 | 666.4637998111 | 1238.0539680832 | 1045.468676694 | 837.3044649042 | 0 | 0 | 1764.2162326308 | 337.4769174838 | 288.9968847374 | 243.8697983791 | 23.1635085778 | 91.1589423752 | 365.0250749319 | 611.9775872035 | 214.4880279233 | 222.3350264229 | 203.9326390715 | 201.1642352125 | 512.4370687878 | 49.64676255690001 | 671.9218718427 | 191.0690730388 | 174.5670295327 | 43172.1267649608
 | 2020 | Beer | k hL | Living | 436.4859396243134 | 323.4178667253699 | 113.0680728989434 | 160.8899924812471 | 275.5959471430664 | 33.35390478986542 | 116.9570874226083 | 135.9881655432617 | 150.1867818685778 | 0 | 145.7200981206268 | 106.8410892539915 | 140.9739257258734 | 42.95082652382173 | 21.9908348658 | 53.16237976390001 | 39.3214093381 | 46.41536851350001 | 11.3630699241 | 63.7947076587 | 96.6667562052 | 103.7714133551 | 0 | 0 | 130.267742606 | 52.8672979148 | 2.307670079 | 4.4966933884 | 3.0634879068 | 0 | 50.2613434167 | 5.6815297978 | 7.390284900599999 | 24.2848797476 | 4.7472790526 | 13.4702925609 | 87.1825353092 | 0.1968029082 | 44.3647231475 | 1.8146567406 | 4.0887201476 | 3055.401577370268
 | 2020 | Beer | k hL | Meals Group | 942.0445240554153 | 942.0445240554153 | 0 | 262.3432003898064 | 679.7013236656097 | 159.0078643620276 | 298.7535532295279 | 218.8562989730058 | 265.4268074908545 | 0 | 257.1904989187342 | 227.3509813297063 | 302.0110619460882 | 155.491981860887 | 71.398822704 | 85.3964361699 | 58.5804998642 | 46.9674416518 | 87.6090416581 | 213.3571170597 | 160.2757991088 | 218.4593658391 | 0 | 0 | 267.3089548214 | 68.0516404537 | 21.9343568869 | 0 | 51.4304038838 | 35.0802057048 | 28.6546224883 | 161.2010168915 | 3.0135456533 | 4.7631369858 | 11.9363012999 | 23.6593599536 | 101.5044883944 | 11.6935692705 | 94.46601362979999 | 24.0001739368 | 33.3467338012 | 6594.311668388377
 | 2020 | Beer | k hL | Social Mixed Gender | 1995.427214899463 | 1134.629142483789 | 860.7980724156755 | 725.5105977991949 | 1269.916617100269 | 378.0837224502004 | 612.3477720212016 | 459.2058495208174 | 545.7898709072444 | 0 | 501.9664544681491 | 475.0081441935699 | 613.8207444506404 | 404.631871787105 | 169.9101745691 | 223.0353306524 | 185.5166028491 | 147.0484897286 | 208.1735478811 | 389.3124413688 | 273.6892466717 | 398.7413811787 | 0 | 0 | 575.5981768268 | 249.0615277537 | 48.3694477789 | 39.3064466914 | 50.03792781689999 | 36.6371271034 | 190.2866352852 | 162.4003310732 | 102.8347786715 | 87.08748620530001 | 109.1458240115 | 46.98090556850001 | 105.0362967957 | 7.2301465102 | 98.24875656340001 | 20.2398346331 | 66.92556561079999 | 13967.99050429632
 | 2020 | Beer | k hL | Social Male | 3097.704792569837 | 1327.428279796645 | 1770.276512773196 | 0 | 3097.704792569837 | 336.3096112353496 | 865.9005441677791 | 811.8298248673174 | 1083.664812299392 | 0 | 681.4858793598161 | 765.848738722413 | 1044.458339037644 | 605.9118354499649 | 0 | 0 | 0 | 0 | 336.3096112353 | 865.9005441678 | 811.8298248673 | 1083.6648122994 | 0 | 0 | 887.3430319499 | 183.6425080204 | 83.87210960680001 | 130.9898833993 | 42.8955290342 | 62.2518404285 | 301.3082473024 | 229.7278541417 | 81.869758148 | 110.4132610084 | 73.61148741779999 | 153.4828240634 | 310.565627212 | 3.8787693329 | 249.2239548287 | 83.11661062569999 | 109.5114960497 | 21683.93354798879
 | 2020 | Beer | k hL | Relax Family | 482.5160715174213 | 482.5160715174213 | 0 | 221.1854770900027 | 261.3305944274189 | 79.42058124133119 | 97.97120119536797 | 163.3453260698926 | 141.77896301083 | 0 | 184.355138230795 | 120.2288022869062 | 108.427504109134 | 69.50462689058644 | 58.3676928061 | 52.5160659994 | 57.42754304850001 | 52.87417523609999 | 21.0528884352 | 45.455135196 | 105.9177830214 | 88.9047877748 | 0 | 0 | 212.8894975883 | 41.5247455903 | 4.3574889225 | 9.0587501505 | 0 | 0 | 15.7503416302 | 32.2188102254 | 20.1875357023 | 3.3785273213 | 35.24943987429999 | 4.6939131263 | 37.9245430904 | 0 | 46.6259331203 | 14.8093915941 | 3.8471535813 | 3377.612500622107
 | 2020 | Beer | k hL | Meals for 1 or 2 | 151.6475965700335 | 151.6475965700335 | 0 | 49.93477665055358 | 101.71281991948 | 13.52036547372698 | 55.40241941530261 | 51.39833001389398 | 31.32648166711003 | 0 | 34.9188509001695 | 76.52694504818206 | 30.96610036714596 | 9.235700254536077 | 7.5719484814 | 22.7677243169 | 14.9201025521 | 4.6750013001 | 5.9484169924 | 32.6346950984 | 36.4782274618 | 26.651480367 | 0 | 0 | 53.22412112270001 | 3.3409959952 | 7.030140164800001 | 2.6899935173 | 0 | 6.0196829096 | 1.5953836466 | 15.5557670993 | 6.681436640199999 | 0.72578937 | 0.4180501203 | 2.7934341252 | 16.7736471481 | 1.8337487793 | 24.2615604899 | 5.2468662861 | 3.4569791554 | 1061.533175990268
 | 2020 | Beer | k hL | Relax alone | 72.45099656277263 | 66.44702179727227 | 6.003974765500346 | 32.84020368855662 | 39.610792874216 | 11.99022158701626 | 30.98378776097405 | 7.844559041393943 | 21.63242817338839 | 0 | 19.27778781572281 | 27.5871914302597 | 13.75902728397116 | 11.82699003281896 | 3.0805701386 | 19.4352376524 | 0.5808662893 | 9.743529608200001 | 8.9096514484 | 11.5485501085 | 7.263692752100001 | 11.8888985652 | 0 | 0 | 16.5105500161 | 5.9331674178 | 4.0648666581 | 0 | 0 | 0 | 1.4594272196 | 5.4225296753 | 5.63440552 | 0 | 1.0270643605 | 7.235328869500001 | 0.7861007198000001 | 1.0591123469 | 4.1901874622 | 0 | 19.1282562969 | 507.1569759392631
 | 2020 | Beer | k hL | Meals ON | 638.5463879569045 | 0 | 638.5463879569045 | 80.83848773400643 | 557.7079002228976 | 90.89353152891252 | 141.2257989519611 | 276.4080956430446 | 130.0189618329861 | 0 | 265.9450363577215 | 189.4063056314663 | 117.8197524446122 | 65.37529352310412 | 2.3959367966 | 22.1366941671 | 31.5447675012 | 24.7610892692 | 88.4975947323 | 119.0891047849 | 244.8633281419 | 105.2578725638 | 0 | 0 | 161.2115364834 | 20.484119182 | 23.4447879131 | 1.3730976494 | 21.9495745963 | 7.0835038293 | 0.295680463 | 83.35624239319999 | 8.7489616478 | 89.1991900267 | 2.273295212 | 17.7831878186 | 92.6838880737 | 14.176834823 | 52.8095899853 | 15.5724235288 | 26.1004743312 | 4469.824715698322
 | 2020 | Beer | k hL | Social with food | 290.0405448335051 | 217.3257595665826 | 72.71478526692253 | 32.39737458439244 | 257.6431702491127 | 11.56480390496646 | 96.72177536776756 | 61.35052071986237 | 120.4034448409087 | 0 | 38.79604041464047 | 63.3546461144095 | 142.9099117256354 | 44.97994657881971 | 1.553847694 | 19.4156203366 | 7.8717248827 | 3.5561816711 | 10.010956211 | 77.30615503109999 | 53.4787958371 | 116.8472631698 | 0 | 0 | 29.3449326217 | 10.4385183448 | 0 | 1.7915369348 | 0.2434558675 | 0 | 12.6645326161 | 24.5118930579 | 8.064471793200001 | 0.3633335331000001 | 10.6977284401 | 22.0654775592 | 69.1098275951 | 2.5996906408 | 80.1554829361 | 0 | 17.9896628931 | 2030.283813834425
 | 2020 | Total Liquid | k hL | Party | 9267.63717709796 | 6628.91738131172 | 2638.719795786244 | 3871.839839834075 | 5395.797337263886 | 1938.186204693303 | 2577.335618314277 | 2536.225501587954 | 2215.889852502429 | 0 | 2703.252745663629 | 2216.466091881687 | 2803.992063093857 | 1543.926276458792 | 768.8395942742 | 953.3879314643 | 1091.8903537472 | 1057.7219603485 | 1169.3466104191 | 1623.94768685 | 1444.3351478408 | 1158.167892154 | 0 | 0 | 3012.184150511 | 685.8311223226 | 391.6761428471 | 277.1340604204 | 109.9216826731 | 208.5412548614 | 433.5201696808 | 732.8908665103 | 283.2480303613 | 322.3236346234 | 288.1376268724 | 280.0999260617 | 720.5275971073002 | 83.5096153977 | 861.2206498029 | 290.3347435463 | 286.5359034979 | 64873.4602396855
 | 2020 | Total Liquid | k hL | Living | 5556.404692407054 | 4733.500586229731 | 822.9041061773316 | 2944.23941872667 | 2612.16527368039 | 1021.913286228446 | 1466.08853932577 | 1407.141065309613 | 1661.261801543237 | 0 | 1395.565575013478 | 1213.364830664532 | 1856.457607254301 | 1091.016679474749 | 572.4211963967 | 846.2621904595 | 701.6243208696001 | 823.9317110009 | 449.4920898318 | 619.8263488662001 | 705.5167444401 | 837.3300905423 | 0 | 0 | 2089.5114987406 | 680.0120525026999 | 116.0890778647 | 131.4967345201 | 59.6796629203 | 34.0686245133 | 414.5780591907 | 194.4331692855 | 120.4359921678 | 110.8828902976 | 155.8111929817 | 53.5484259745 | 547.0391949898001 | 15.3363358018 | 371.5949922331 | 182.3629201773 | 279.5238682456 | 38894.8328468495
 | 2020 | Total Liquid | k hL | Meals Group | 5233.863837184627 | 5233.863837184627 | 0 | 2497.428654987747 | 2736.435182196892 | 1014.88060659326 | 1319.928157705391 | 1265.375668138617 | 1633.679404747373 | 0 | 1489.264890089002 | 1242.129353454921 | 1451.808925383881 | 1050.660668256842 | 568.8440955330001 | 599.9092227558 | 620.6368018235 | 708.0385348755 | 446.0365110602 | 720.0189349496001 | 644.7388663152 | 925.6408698719 | 0 | 0 | 1700.8214055162 | 943.8942765538001 | 97.63577818430001 | 8.915805712200001 | 179.528289139 | 204.8760083984 | 370.3319709867 | 275.2048407458 | 61.93969210310001 | 80.50397681060001 | 106.2753288703 | 46.0670095151 | 529.3099351186 | 34.8462774515 | 290.9235863969 | 94.8827122894 | 207.9069433926 | 36637.04686029236
 | 2020 | Total Liquid | k hL | Social Mixed Gender | 4626.150794619958 | 3354.02072030988 | 1272.13007431007 | 2144.668596276907 | 2481.482198343042 | 1116.877228680961 | 1271.981897531155 | 1077.606534416692 | 1159.685133991144 | 0 | 1176.077260489485 | 1148.748672539002 | 1361.956111090892 | 939.3687505005748 | 599.6901090795 | 501.1241697681 | 572.1974297166 | 471.6568877127 | 517.1871196014 | 770.8577277631 | 505.4091047001 | 688.0282462783999 | 0 | 0 | 1474.0244748234 | 593.4025787354 | 77.2543200392 | 60.5927054653 | 85.97453491790002 | 74.1653983528 | 268.3220582748 | 268.1624021353 | 196.9203620815 | 183.1112150799 | 278.5998815648 | 78.7180931595 | 291.0320443597 | 26.5917205313 | 289.46058642 | 99.7782188668 | 280.0401998125 | 32383.05556233977
 | 2020 | Total Liquid | k hL | Social Male | 4374.476790665572 | 2237.838689281976 | 2136.638101383597 | 0 | 4374.476790665572 | 726.8072793618956 | 1229.731779394397 | 1079.402969310973 | 1338.534762598311 | 0 | 979.6032602608847 | 1152.891436807425 | 1353.854314519954 | 888.1277790773145 | 0 | 0 | 0 | 0 | 726.8072793619 | 1229.7317793944 | 1079.402969311 | 1338.5347625983 | 0 | 0 | 1283.247774431 | 326.1381932004 | 116.997861956 | 179.5601615047 | 48.8528744801 | 77.566574788 | 353.2569547489 | 250.5183285797 | 126.3291188243 | 249.7416079362 | 132.4776988686 | 204.9654226745 | 382.5488926076999 | 15.7934428817 | 269.9756056489 | 125.5477726659 | 230.9585048692 | 30621.33753465927
 | 2020 | Total Liquid | k hL | Relax Family | 2124.392920470525 | 2124.392920470525 | 0 | 1287.643524854672 | 836.7493956158506 | 404.4025458103106 | 699.285700681497 | 579.3808955710963 | 441.3237784076206 | 0 | 851.66465265136 | 448.3491020506913 | 471.6769718715258 | 352.7021938969477 | 310.8269508424 | 451.3186739256 | 278.2326169692 | 247.2652831175 | 93.57559496799999 | 247.9670267559 | 301.1482786019 | 194.0584952901 | 0 | 0 | 906.711789503 | 175.0458935583 | 35.727940546 | 13.251818938 | 0 | 22.5915442531 | 139.0697314072 | 86.2702576283 | 56.925551234 | 28.1627348248 | 114.9794018 | 142.3012112582 | 135.1078867914 | 13.4933242194 | 98.84194847639999 | 58.1771238874 | 97.7347621449 | 14870.75044329362
 | 2020 | Total Liquid | k hL | Meals for 1 or 2 | 1681.434546478785 | 1681.434546478785 | 0 | 835.551977506591 | 845.8825689721948 | 352.4524402223017 | 513.9592483435279 | 390.8668022484264 | 424.1560556645305 | 0 | 451.3023033992626 | 424.886958748313 | 559.7520778247939 | 245.493206506417 | 200.3026520308 | 297.3759026553 | 139.3736961765 | 198.499726644 | 152.1497881915 | 216.5833456882 | 251.4931060719 | 225.6563290206 | 0 | 0 | 657.9766414023001 | 139.9068833666 | 93.51165673870001 | 13.9804708152 | 10.9308189383 | 29.6593500099 | 52.833059735 | 111.8592669694 | 50.0377661702 | 18.1170105859 | 61.0433129489 | 12.1962516013 | 175.6345234688 | 22.6334270741 | 60.46431576810001 | 51.6535056463 | 118.9962852398 | 11770.04182535153
 | 2020 | Total Liquid | k hL | Relax alone | 1440.940230536918 | 1325.755293477104 | 115.1849370598146 | 648.4589023810325 | 792.4813281558854 | 415.2743588120346 | 408.7854473323566 | 231.9318163642603 | 384.9486080282667 | 0 | 437.175248676214 | 237.7044012814961 | 510.6699328429928 | 255.3906477362154 | 196.8174056736 | 185.3974892357 | 85.17857382140001 | 181.0654336503 | 218.4569531385 | 223.3879580966 | 146.7532425428 | 203.883174378 | 0 | 0 | 508.6440522706 | 136.8861074138 | 67.7465112241 | 36.6625852755 | 2.3444420032 | 36.212135513 | 44.0657588388 | 125.6626366616 | 55.0836234081 | 30.6205780686 | 21.9993012406 | 49.0472848531 | 72.57487026359999 | 18.0174892525 | 27.5432008807 | 75.0816145503 | 132.7480388187 | 10086.5816137583
 | 2020 | Total Liquid | k hL | Meals ON | 1372.296918659394 | 0 | 1372.296918659394 | 348.6252487873462 | 1023.671669872048 | 302.7649958816126 | 357.4579199937637 | 452.0731968915796 | 260.0008058924385 | 0 | 533.4622785441758 | 354.2908954811265 | 345.1679774977102 | 139.3757671363824 | 72.2181288487 | 106.8931044941 | 94.15579499430001 | 75.3582204504 | 230.546867033 | 250.5648154997 | 357.9174018973 | 184.6425854421 | 0 | 0 | 405.9811785626 | 112.7521700473 | 51.4136073939 | 20.1771322335 | 46.3768431582 | 22.2115023045 | 22.4799052214 | 94.8658187127 | 36.9310788792 | 105.363340745 | 20.421913015 | 54.9505884877 | 156.6346829036 | 51.338084543 | 69.9201664835 | 21.1058321839 | 79.37307378439999 | 9606.078430615971
 | 2020 | Total Liquid | k hL | Social with food | 713.3277937723398 | 564.4720880655472 | 148.8557057067925 | 141.6782874577208 | 571.6495063146189 | 93.34053038536626 | 291.1875847790458 | 131.4263524040389 | 197.373326203889 | 0 | 114.8675333358239 | 281.4224160915401 | 200.701924489906 | 116.33591985507 | 31.1366723116 | 36.0778018338 | 33.1135549742 | 41.3502583381 | 62.2038580737 | 255.1097829452 | 98.3127974299 | 156.0230678658 | 0 | 0 | 108.074575366 | 33.0559206787 | 12.9294370468 | 1.7915369348 | 0.2434558675 | 0 | 24.7588252533 | 37.4227365473 | 25.1092661504 | 3.4424040551 | 19.0445590329 | 23.1999175923 | 77.27778230220001 | 2.5996906408 | 242.5310120927 | 4.6969611413 | 97.14971307030001 | 4993.294556406398
 | 2019 | Beer | k hL | Party
 | 2019 | Beer | k hL | Living
 | 2019 | Beer | k hL | Meals Group
 | 2019 | Beer | k hL | Social Mixed Gender
 | 2019 | Beer | k hL | Social Male
 | 2019 | Beer | k hL | Relax Family
 | 2019 | Beer | k hL | Meals for 1 or 2
 | 2019 | Beer | k hL | Relax alone
 | 2019 | Beer | k hL | Meals ON
 | 2019 | Beer | k hL | Social with food
 | 2019 | Total Liquid | k hL | Party
 | 2019 | Total Liquid | k hL | Living
 | 2019 | Total Liquid | k hL | Meals Group
 | 2019 | Total Liquid | k hL | Social Mixed Gender
 | 2019 | Total Liquid | k hL | Social Male
 | 2019 | Total Liquid | k hL | Relax Family
 | 2019 | Total Liquid | k hL | Meals for 1 or 2
 | 2019 | Total Liquid | k hL | Relax alone
 | 2019 | Total Liquid | k hL | Meals ON
 | 2019 | Total Liquid | k hL | Social with food
 | 2018 | Beer | k hL | Party
 | 2018 | Beer | k hL | Living
 | 2018 | Beer | k hL | Meals Group
 | 2018 | Beer | k hL | Social Mixed Gender
 | 2018 | Beer | k hL | Social Male
 | 2018 | Beer | k hL | Relax Family
 | 2018 | Beer | k hL | Meals for 1 or 2
 | 2018 | Beer | k hL | Relax alone
 | 2018 | Beer | k hL | Meals ON
 | 2018 | Beer | k hL | Social with food
 | 2018 | Total Liquid | k hL | Party
 | 2018 | Total Liquid | k hL | Living
 | 2018 | Total Liquid | k hL | Meals Group
 | 2018 | Total Liquid | k hL | Social Mixed Gender
 | 2018 | Total Liquid | k hL | Social Male
 | 2018 | Total Liquid | k hL | Relax Family
 | 2018 | Total Liquid | k hL | Meals for 1 or 2
 | 2018 | Total Liquid | k hL | Relax alone
 | 2018 | Total Liquid | k hL | Meals ON
 | 2018 | Total Liquid | k hL | Social with food
 | 2017 | Beer | k hL | Party
 | 2017 | Beer | k hL | Living
 | 2017 | Beer | k hL | Meals Group
 | 2017 | Beer | k hL | Social Mixed Gender
 | 2017 | Beer | k hL | Social Male
 | 2017 | Beer | k hL | Relax Family
 | 2017 | Beer | k hL | Meals for 1 or 2
 | 2017 | Beer | k hL | Relax alone
 | 2017 | Beer | k hL | Meals ON
 | 2017 | Beer | k hL | Social with food
 | 2017 | Total Liquid | k hL | Party
 | 2017 | Total Liquid | k hL | Living
 | 2017 | Total Liquid | k hL | Meals Group
 | 2017 | Total Liquid | k hL | Social Mixed Gender
 | 2017 | Total Liquid | k hL | Social Male
 | 2017 | Total Liquid | k hL | Relax Family
 | 2017 | Total Liquid | k hL | Meals for 1 or 2
 | 2017 | Total Liquid | k hL | Relax alone
 | 2017 | Total Liquid | k hL | Meals ON
 | 2017 | Total Liquid | k hL | Social with food
 | 2016 | Beer | k hL | Party
 | 2016 | Beer | k hL | Living
 | 2016 | Beer | k hL | Meals Group
 | 2016 | Beer | k hL | Social Mixed Gender
 | 2016 | Beer | k hL | Social Male
 | 2016 | Beer | k hL | Relax Family
 | 2016 | Beer | k hL | Meals for 1 or 2
 | 2016 | Beer | k hL | Relax alone
 | 2016 | Beer | k hL | Meals ON
 | 2016 | Beer | k hL | Social with food
 | 2016 | Total Liquid | k hL | Party
 | 2016 | Total Liquid | k hL | Living
 | 2016 | Total Liquid | k hL | Meals Group
 | 2016 | Total Liquid | k hL | Social Mixed Gender
 | 2016 | Total Liquid | k hL | Social Male
 | 2016 | Total Liquid | k hL | Relax Family
 | 2016 | Total Liquid | k hL | Meals for 1 or 2
 | 2016 | Total Liquid | k hL | Relax alone
 | 2016 | Total Liquid | k hL | Meals ON
 | 2016 | Total Liquid | k hL | Social with food