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

 |  |  |  |  |  |  |  |  | Scenarios
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50
Source | Source 2 | Occasion | Age | Gender | Income level | Channel | Region | Value
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | High | Off |  | 141398279.6738952
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | medium-high | Off |  | 413943018.8309845
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | medium-high | On |  | 408566406.7843808
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | medium-low | Off |  | 125841217.515748
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | medium-low | On |  | 46558069.60043314
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | High | Off |  | 222057408.2270611
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | High | On |  | 7421899.029765889
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | medium-high | Off |  | 483046903.1806625
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | medium-low | Off |  | 368559068.0752778
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | medium-low | On |  | 806012021.732059
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | LDA-24 | Female | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | High | Off |  | 1852454779.327348
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | High | On |  | 454842635.5871462
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | medium-high | Off |  | 2090960584.924981
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | medium-high | On |  | 111472251.993535
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | medium-low | Off |  | 1320064352.377923
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | Low | Off |  | 189895436.1544724
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | High | Off |  | 512593442.7852551
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | High | On |  | 1124452427.024595
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | medium-high | Off |  | 1287138218.421723
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | medium-high | On |  | 209849664.3535455
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | medium-low | Off |  | 1150958085.251138
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | Low | Off |  | 579649695.7900592
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 25-34 | Female | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | High | Off |  | 1076628932.846118
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | High | On |  | 942695504.320368
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | medium-high | Off |  | 429329487.661243
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | medium-low | Off |  | 3287173617.371103
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | medium-low | On |  | 1696002027.8241
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | Low | Off |  | 1274661276.065141
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Male | Low | On |  | 84063961.8309619
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | High | Off |  | 668508866.0962144
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | High | On |  | 423679457.6567442
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | medium-high | Off |  | 585201228.181084
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | medium-high | On |  | 414570523.8461957
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | medium-low | Off |  | 585620015.6278219
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | medium-low | On |  | 822748275.7049041
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | Low | Off |  | 380015657.8111596
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 35-44 | Female | Low | On |  | 48144178.2107677
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | High | Off |  | 3744931686.883313
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | High | On |  | 286331588.2793164
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | medium-high | Off |  | 2722118722.706967
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | medium-low | Off |  | 1166774964.514409
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Male | Low | On |  | 1003585527.803705
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | High | Off |  | 962143737.1352667
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | High | On |  | 186437021.8916686
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | medium-high | Off |  | 183736577.7274166
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | medium-high | On |  | 405320029.8442297
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | medium-low | Off |  | 2484460603.574136
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Living | 45-54 | Female | Low | On |  | 404044797.6338331
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | High | Off |  | 156636227.3628513
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | medium-high | Off |  | 157693419.5101066
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | medium-low | Off |  | 194591492.0188164
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | Low | Off |  | 61138000.6447734
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | High | Off |  | 21549276.15182652
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | medium-high | Off |  | 595101329.1059422
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | medium-low | Off |  | 92000555.95277892
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | Low | Off |  | 70092963.07683882
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | LDA-24 | Female | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | High | Off |  | 180313475.8398064
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | medium-high | Off |  | 114496113.6101917
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | medium-low | Off |  | 1206558324.366263
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | Low | Off |  | 357285283.7821978
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | High | Off |  | 1412320827.391296
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | medium-high | Off |  | 510718067.2133363
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | medium-low | Off |  | 299886007.7588023
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | Low | Off |  | 111154268.4640243
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 25-34 | Female | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | High | Off |  | 800046784.0699164
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | medium-high | Off |  | 2172174228.240895
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | medium-low | Off |  | 1817512953.569403
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | High | Off |  | 633589940.2790291
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | medium-high | Off |  | 326402658.8449675
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | medium-low | Off |  | 234203538.3651589
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | Low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 35-44 | Female | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | High | Off |  | 391068720.4027593
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | medium-high | Off |  | 1758895050.869371
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | medium-low | Off |  | 2147277156.458002
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | Low | Off |  | 346976262.485144
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Male | Low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | High | Off |  | 74695208.77826437
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | High | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | medium-high | Off |  | 347186082.5977618
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | medium-high | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | medium-low | Off
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | medium-low | On
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | Low | Off |  | 38061247.64540275
Global | Key Occasions | Global | ABI Beer Style Volume (ml) | Classic Lager beer | Meals for 1 or 2 | 45-54 | Female | Low | On