Spreadsheet: 41277d1239770285-find-value-from-multiple-tables-inventory-bar-v8
Sheet: Extract

2009-04-09 00:00:00 |  |  |  |  | 2009-04-10 00:00:00 |  |  |  |  | 2009-04-11 00:00:00
Revenue Centers Selected: ALL |  |  |  |  | Revenue Centers Selected: ALL |  |  |  |  | Revenue Centers Selected: ALL
 |  | Item |  | Num |  |  | Item |  | Num |  |  | Item |  | Num
Rank | Category | Num | Item Name | Sold | Rank | Category | Num | Item Name | Sold | Rank | Category | Num | Item Name | Sold
1 | EVERYTHNG | 15029 | piaze vecchio | 2 | 1 | EVERYTHNG | 4561 | Wrap | 1 | 1 | EVERYTHNG | 10048 | [NAME] | 1
2 |  | 15028 | bellwether | 2 | 2 |  | 4562 | Panini | 4 | 2 |  | 28257 | Split | 1
3 |  | 15027 | blue shropshire | 2 |  |  |  |  | ------------ | 3 |  | 4561 | Wrap | 2
4 |  | 4561 | Wrap | 3 |  |  |  | Tot EVERYTHNG: | 5 | 4 |  | 28306 | Male | 1
5 |  | 4562 | Panini | 1 |  |  |  |  |  | 5 |  | 4562 | Panini | 5
 |  |  |  | ------------ | 1 | LIQUOR | 125089 | Svedka | 240 | 6 |  | 15029 | piaze vecchio | 1
 |  |  | Tot EVERYTHNG: | 10 | 2 |  | 30103 | Open\nLiquor | 2 | 7 |  | 15028 | bellwether | 1
 |  |  |  |  | 3 |  | 125036 | Grey\nGoose | 64 | 8 |  | 15027 | blue shropshire | 1
1 | LIQUOR | 125089 | Svedka | 152 | 4 |  | 125018 | Effen Blk/Chry | 35 |  |  |  |  | ------------
2 |  | 125018 | Effen Blk/Chry | 32 | 5 |  | 125071 | Stoli | 32 |  |  |  | Tot EVERYTHNG: | 13
3 |  | 110011 | [NAME] | 36 | 6 |  | 100020 | Jack\nDaniels | 29
4 |  | 125036 | Grey\nGoose | 26 | 7 |  | 125006 | [NAME] | 30 | 1 | LIQUOR | 125089 | Svedka | 212
5 |  | 145008 | Cosmo Perfect | 11 | 8 |  | 147234 | Long Island | 19 | 2 |  | 30103 | Open\nLiquor | 3
6 |  | 125006 | [NAME] | 17 | 9 |  | 120033 | Patron\nSilver | 28 | 3 |  | 110011 | [NAME] | 48
7 |  | 125071 | Stoli | 15 | 10 |  | 110021 | Captain\nMorgan | 19 | 4 |  | 120033 | Patron\nSilver | 37
8 |  | 105031 | Tanqueray | 14 | 11 |  | 145008 | Cosmo Perfect | 11 | 5 |  | 125018 | Effen Blk/Chry | 47
9 |  | 125075 | Stoli\nRaspbery | 21 | 12 |  | 125079 | Stoli\nBluberry | 17 | 6 |  | 125036 | Grey\nGoose | 37
10 |  | 145657 | clear martini | 19 | 13 |  | 145657 | clear martini | 23 | 7 |  | 100020 | Jack\nDaniels | 36
11 |  | 125051 | Ketel\nOne | 15 | 14 |  | 100041 | Maker's\nMark | 16 | 8 |  | 147469 | Mojito | 17
12 |  | 110021 | Captain\nMorgan | 17 | 15 |  | 105031 | Tanqueray | 14 | 9 |  | 105012 | Bombay\nSapp | 18
13 |  | 100051 | South\nComfort | 11 | 16 |  | 145016 | [NAME] | 9 | 10 |  | 125021 | Belvedere | 19
14 |  | 100020 | Jack\nDaniels | 10 | 17 |  | 125075 | Stoli\nRaspbery | 12 | 11 |  | 125051 | Ketel\nOne | 19
15 |  | 120033 | Patron\nSilver | 8 | 18 |  | 110011 | [NAME] | 10 | 12 |  | 147234 | Long Island | 17
16 |  | 30103 | Open\nLiquor | 11 | 19 |  | 145009 | Flirtini | 5 | 13 |  | 125006 | [NAME] | 16
17 |  | 147234 | Long Island | 7 | 20 |  | 147469 | Mojito | 5 | 14 |  | 145016 | [NAME] | 12
18 |  | 125079 | Stoli\nBluberry | 10 | 21 |  | 135206 | [NAME] | 12 | 15 |  | 125075 | Stoli\nRaspbery | 16
19 |  | 105012 | Bombay\nSapp | 7 | 22 |  | 660238 | chocolate tini | 4 | 16 |  | 147417 | mini marg | 9
20 |  | 125005 | Infusion | 6 | 23 |  | 147418 | french martini | 4 | 17 |  | 110021 | Captain\nMorgan | 16
21 |  | 125021 | Belvedere | 6 | 24 |  | 146064 | FrenchPear Tini | 3 | 18 |  | 105001 | Seagrams | 13
22 |  | 147419 | [NAME] | 11 | 25 |  | 125055 | Sved Clementine | 7 | 19 |  | 145008 | Cosmo Perfect | 15
23 |  | 145009 | Flirtini | 4 | 26 |  | 125005 | Infusion | 5 | 20 |  | 145657 | clear martini | 18
24 |  | 660237 | KeyLimePie Mart | 3 | 27 |  | 105019 | [NAME] | 5 | 21 |  | 135178 | Svedka Citron | 10
25 |  | 135206 | [NAME] | 10 | 28 |  | 147419 | [NAME] | 10 | 22 |  | 135206 | [NAME] | 10
26 |  | 660051 | VanGogh Choc | 6 | 29 |  | 125051 | Ketel\nOne | 5 | 23 |  | 110017 | Bacardi\nO | 8
27 |  | 105019 | [NAME] | 4 | 30 |  | 130026 | Jameson's | 5 | 24 |  | 125079 | Stoli\nBluberry | 10
28 |  | 135041 | Bailey's | 4 | 31 |  | 147417 | mini marg | 3 | 25 |  | 105031 | Tanqueray | 7
29 |  | 110017 | Bacardi\nO | 4 | 32 |  | 149363 | White Star Gls | 2 | 26 |  | 110008 | [NAME] | 8
30 |  | 146064 | FrenchPear Tini | 2 | 33 |  | 640003 | [NAME] | 5 | 27 |  | 125055 | Sved Clementine | 8
31 |  | 100041 | Maker's\nMark | 4 | 34 |  | 100051 | South\nComfort | 4 | 28 |  | 650038 | blueberry mart | 4
32 |  | 230002 | Double | 5 | 35 |  | 145626 | [NAME] | 2 | 29 |  | 115066 | J.W.\nBlack | 6
33 |  | 660238 | chocolate tini | 2 | 36 |  | 650038 | blueberry mart | 2 | 30 |  | 125005 | Infusion | 6
34 |  | 640003 | [NAME] | 5 | 37 |  | 105001 | Seagrams | 4 | 31 |  | 660052 | VanGogh BlueBer | 6
35 |  | 145016 | [NAME] | 2 | 38 |  | 125083 | Stoli Citros | 4 | 32 |  | 147418 | french martini | 5
36 |  | 130026 | Jameson's | 5 | 39 |  | 230002 | Double | 3 | 33 |  | 110026 | Malibu | 6
37 |  | 125037 | Grey\nGoose O | 4 | 40 |  | 110017 | Bacardi\nO | 4 | 34 |  | 130026 | Jameson's | 7
38 |  | 147469 | Mojito | 2 | 41 |  | 120039 | Sauza\nGold | 3 | 35 |  | 125026 | Chopin | 5
39 |  | 660243 | Absinthe Minded | 2 | 42 |  | 147421 | Tanqueray 10 | 2 | 36 |  | 130021 | Crown\nRoyal | 5
40 |  | 130031 | Seagram\n7 | 3 | 43 |  | 125047 | [NAME] | 2 | 37 |  | 640003 | [NAME] | 5
41 |  | 125055 | Sved Clementine | 7 | 44 |  | 125052 | Ketel Citroen | 2 | 38 |  | 125052 | Ketel Citroen | 5
42 |  | 660251 | PINK | 2 | 45 |  | 125021 | Belvedere | 2 | 39 |  | 145696 | [NAME] | 17
43 |  | 147418 | french martini | 2 | 46 |  | 125037 | Grey\nGoose O | 2 | 40 |  | 235000 | Disarono | 5
44 |  | 115021 | Chivas\nRegal | 2 | 47 |  | 650047 | GingerGingerAle | 2 | 41 |  | 660243 | Absinthe Minded | 3
45 |  | 125076 | [NAME] | 2 | 48 |  | 115053 | Glenlivet | 2 | 42 |  | 660246 | capir - pn&mint | 3
46 |  | 115053 | Glenlivet | 2 | 49 |  | 650040 | espresso tini | 1 | 43 |  | 660239 | Mojito - Straw | 3
47 |  | 660227 | Lucid Absinthe | 5 | 50 |  | 650046 | Hot & Dirty | 1 | 44 |  | 125019 | Effen | 5
48 |  | 135291 | Rumpleminze | 2 | 51 |  | 110008 | [NAME] | 2 | 45 |  | 125029 | Ciroc | 4
49 |  | 145696 | [NAME] | 1 | 52 |  | 660231 | [NAME] | 2 | 46 |  | 100041 | Maker's\nMark | 7
50 |  | 110008 | [NAME] | 2 | 53 |  | 135291 | Rumpleminze | 2 | 47 |  | 650040 | espresso tini | 3
51 |  | 149363 | White Star Gls | 2 | 54 |  | 146222 | GreenTIceCream | 1 | 48 |  | 147419 | [NAME] | 6
52 |  | 660052 | VanGogh BlueBer | 1 | 55 |  | 145010 | [NAME] | 1 | 49 |  | 120039 | Sauza\nGold | 4
53 |  | 145486 | Cosmo | 2 | 56 |  | 147427 | [NAME] | 1 | 50 |  | 147255 | tropical dream | 3
54 |  | 660241 | Green Tea Fizz | 1 | 57 |  | 660042 | caipirinha | 1 | 51 |  | 660042 | caipirinha | 2
55 |  | 135075 | Right! Gin | 1 | 58 |  | 660243 | Absinthe Minded | 1 | 52 |  | 110014 | Bacardi\nLimon | 3
56 |  | 100031 | Jim\nBeam | 1 | 59 |  | 145007 | Pineapple upsid | 1 | 53 |  | 125047 | [NAME] | 6
57 |  | 125074 | Stoli\nOrange | 1 | 60 |  | 660227 | Lucid Absinthe | 1 | 54 |  | 650035 | Citroncello | 2
58 |  | 115046 | Dewars\nWhite | 1 | 61 |  | 650035 | Citroncello | 1 | 55 |  | 100051 | South\nComfort | 2
59 |  | 140021 | Christ\nBrother | 1 | 62 |  | 105012 | Bombay\nSapp | 1 | 56 |  | 125071 | Stoli | 2
60 |  | 135018 | upcharge $ | 5 | 63 |  | 145442 | EmployeeRedBull | 4 | 57 |  | 130031 | Seagram\n7 | 2
61 |  | 146231 | Upcharge | 3 | 64 |  | 135018 | upcharge $ | 8 | 58 |  | 135296 | Sambucca | 2
62 |  | 135211 | Kahlua | 1 | 65 |  | 147648 | Snow Queen | 1 | 59 |  | 660278 | [NAME] | 1
63 |  | 220002 | 7Up | 3 | 66 |  | 660241 | Green Tea Fizz | 1 | 60 |  | 135171 | Goldschlager | 2
64 |  | 135171 | Goldschlager | 1 | 67 |  | 135041 | Bailey's | 1 | 61 |  | 145007 | Pineapple upsid | 3
65 |  | 220036 | Diet\nCoke | 6 | 68 |  | 110036 | Myer's\nDark | 1 | 62 |  | 120032 | Patron\nAnejo | 1
66 |  | 220026 | [NAME] | 1 | 69 |  | 100031 | Jim\nBeam | 1 | 63 |  | 147421 | Tanqueray 10 | 2
67 |  | 220118 | With\nJuice | 1 | 70 |  | 148537 | Sex\non Beach | 1 | 64 |  | 146407 | coffee | 5
68 |  | 220096 | Tonic | 3 | 71 |  | 110026 | Malibu | 1 | 65 |  | 100038 | Knob\nCreek | 1
69 |  | 240026 | Lime | 1 | 72 |  | 130031 | Seagram\n7 | 2 | 66 |  | 135018 | upcharge $ | 8
70 |  | 220016 | Club\nSoda | 3 | 73 |  | 125076 | [NAME] | 1 | 67 |  | 125017 | Charbay Tea | 1
71 |  | 220116 | With\nSoda | 15 | 74 |  | 135178 | Svedka Citron | 1 | 68 |  | 660241 | Green Tea Fizz | 2
72 |  | 230026 | Rocks | 4 | 75 |  | 110014 | Bacardi\nLimon | 2 | 69 |  | 230002 | Double | 6
73 |  | 230028 | Shot | 98 | 76 |  | 220016 | Club\nSoda | 4 | 70 |  | 147403 | Madras | 1
74 |  | 660088 | Gun | 277 | 77 |  | 220096 | Tonic | 2 | 71 |  | 135086 | Campari | 1
 |  |  |  | ------------ | 78 |  | 220036 | Diet\nCoke | 8 | 72 |  | 135090 | [NAME] | 1
 |  |  | Tot LIQUOR: | 993 | 79 |  | 220116 | With\nSoda | 14 | 73 |  | 125084 | house shot | 17
 |  |  |  |  | 80 |  | 220026 | [NAME] | 4 | 74 |  | 240026 | Lime | 3
1 | BEER | 35042 | [NAME] Lt | 40 | 81 |  | 220118 | With\nJuice | 4 | 75 |  | 240056 | Twist | 1
2 |  | 35094 | [NAME] | 11 | 82 |  | 230026 | Rocks | 6 | 76 |  | 240036 | Olives | 1
3 |  | 35096 | 312 | 11 | 83 |  | 230028 | Shot | 152 | 77 |  | 145442 | EmployeeRedBull | 5
4 |  | 40045 | Heineken | 6 | 84 |  | 130021 | Crown\nRoyal | 1 | 78 |  | 230028 | Shot | 186
5 |  | 40021 | Stella | 5 | 85 |  | 660088 | Gun | 326 | 79 |  | 146230 | upcharge x 2 | 1
6 |  | 40024 | Corona | 5 |  |  |  |  | ------------ | 80 |  | 110036 | Myer's\nDark | 1
7 |  | 40000 | Amstel Lt | 2 |  |  |  | Tot LIQUOR: | 1293 | 81 |  | 660238 | chocolate tini | 1
8 |  | 35099 | [NAME] | 1 |  |  |  |  |  | 82 |  | 145626 | [NAME] | 4
 |  |  |  | ------------ | 1 | BEER | 35042 | [NAME] Lt | 81 | 83 |  | 230026 | Rocks | 18
 |  |  | Tot BEER: | 81 | 2 |  | 40000 | Amstel Lt | 20 | 84 |  | 145009 | Flirtini | 2
 |  |  |  |  | 3 |  | 40021 | Stella | 12 | 85 |  | 650046 | Hot & Dirty | 2
1 | WINE | 660005 | Sb - Ferr-Caran | 16 | 4 |  | 35094 | [NAME] | 16 | 86 |  | 660237 | KeyLimePie Mart | 4
2 |  | 30105 | Open\nWine | 1 | 5 |  | 40045 | Heineken | 11 | 87 |  | 135012 | Amaretto\nDisar | 3
3 |  | 630000 | [NAME] | 4 | 6 |  | 35097 | Fat Tire | 5 | 88 |  | 650037 | Pearadise | 9
4 |  | 660028 | MLB - UrbanUco | 9 | 7 |  | 40024 | Corona | 3 | 89 |  | 146064 | FrenchPear Tini | 12
5 |  | 660021 | PN - LaboureRoi | 2 | 8 |  | 35041 | [NAME] | 3 | 90 |  | 660088 | Gun | 390
6 |  | 660094 | Concannon | 4 | 9 |  | 40040 | Guinness | 1 | 91 |  | 220036 | Diet\nCoke | 3
7 |  | 99013 | CHD NavarraCorr | 2 | 10 |  | 40019 | Hoegaarden | 1 | 92 |  | 220016 | Club\nSoda | 19
8 |  | 660002 | PG - Tangent | 2 | 11 |  | 35098 | GI: Honkers Ale | 1 | 93 |  | 220022 | Coke | 1
9 |  | 660223 | Raimat CAB | 2 | 12 |  | 35099 | [NAME] | 1 | 94 |  | 220116 | With\nSoda | 23
10 |  | 99014 | CHD Laboure PF | 1 |  |  |  |  | ------------ | 95 |  | 220026 | [NAME] | 8
11 |  | 660006 | RSL - Wente | 1 |  |  |  | Tot BEER: | 155 | 96 |  | 220118 | With\nJuice | 9
 |  |  |  | ------------ |  |  |  |  |  |  |  |  |  | ------------
 |  |  | Tot WINE: | 44 | 1 | WINE | 660094 | Concannon | 14 |  |  |  | Tot LIQUOR: | 1588
 |  |  |  |  | 2 |  | 660226 | MichaelSullberg | 10
1 | BEVERAGES | 33001 | BOMB RedBull | 24 | 3 |  | 630000 | [NAME] | 5 | 1 | BEER | 35042 | [NAME] Lt | 52
2 |  | 33005 | BOMB SF RedBull | 25 | 4 |  | 660223 | Raimat CAB | 7 | 2 |  | 40045 | Heineken | 25
3 |  | 33073 | Red\nBull | 2 | 5 |  | 660006 | RSL - Wente | 4 | 3 |  | 35094 | [NAME] | 17
4 |  | 33036 | Club\nSoda | 1 | 6 |  | 660005 | Sb - Ferr-Caran | 3 | 4 |  | 40024 | Corona | 11
 |  |  |  | ------------ | 7 |  | 660027 | SRH - Petite | 2 | 5 |  | 35003 | Blue Moon | 12
 |  |  | Tot BEVERAGES: | 52 | 8 |  | 99013 | CHD NavarraCorr | 3 | 6 |  | 40021 | Stella | 6
 |  |  |  |  | 9 |  | 660028 | MLB - UrbanUco | 3 | 7 |  | 35096 | 312 | 7
 |  |  |  |  | 10 |  | 99012 | SB [NAME] | 1 | 8 |  | 40000 | Amstel Lt | 4
 |  |  |  |  | 11 |  | 660224 | Golan | 1 | 9 |  | 40040 | Guinness | 3
 |  |  |  |  | 12 |  | 660003 | PG - Colterenzi | 1 | 10 |  | 35041 | [NAME] | 3
 |  |  |  |  | 13 |  | 660008 | CB - Kanu | 1 | 11 |  | 40006 | [NAME] | 2
 |  |  |  |  |  |  |  |  | ------------ | 12 |  | 40019 | Hoegaarden | 1
 |  |  |  |  |  |  |  | Tot WINE: | 55 | 13 |  | 35099 | [NAME] | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ------------
 |  |  |  |  | 1 | BEVERAGES | 33001 | BOMB RedBull | 82 |  |  |  | Tot BEER: | 144
 |  |  |  |  | 2 |  | 33005 | BOMB SF RedBull | 18
 |  |  |  |  | 3 |  | 330041 | [NAME] | 4 | 1 | WINE | 660005 | Sb - Ferr-Caran | 12
 |  |  |  |  | 4 |  | 27557 | Red\nBull SF | 2 | 2 |  | 660094 | Concannon | 11
 |  |  |  |  | 5 |  | 33000 | Coke | 4 | 3 |  | 660002 | PG - Tangent | 7
 |  |  |  |  | 6 |  | 33073 | Red\nBull | 3 | 4 |  | 660027 | SRH - Petite | 5
 |  |  |  |  | 7 |  | 33012 | Sprite | 2 | 5 |  | 99014 | CHD Laboure PF | 4
 |  |  |  |  | 8 |  | 33036 | Club\nSoda | 1 | 6 |  | 660009 | GRK - Santorini | 3
 |  |  |  |  |  |  |  |  | ------------ | 7 |  | 99013 | CHD NavarraCorr | 4
 |  |  |  |  |  |  |  | Tot BEVERAGES: | 116 | 8 |  | 660224 | Golan | 2
 |  |  |  |  |  |  |  |  |  | 9 |  | 660028 | MLB - UrbanUco | 3
 |  |  |  |  |  |  |  |  |  | 10 |  | 660226 | MichaelSullberg | 2
 |  |  |  |  |  |  |  |  |  | 11 |  | 660003 | PG - Colterenzi | 1
 |  |  |  |  |  |  |  |  |  | 12 |  | 660026 | Rose - A to Z | 1
 |  |  |  |  |  |  |  |  |  | 13 |  | 660006 | RSL - Wente | 1
 |  |  |  |  |  |  |  |  |  | 14 |  | 660223 | Raimat CAB | 1
 |  |  |  |  |  |  |  |  |  | 15 |  | 660000 | CHRD-LouisLatou | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ------------
 |  |  |  |  |  |  |  |  |  |  |  |  | Tot WINE: | 58
 |  |  |  |  |  |  |  |  |  | 1 | BEVERAGES | 33001 | BOMB RedBull | 34
 |  |  |  |  |  |  |  |  |  | 2 |  | 33005 | BOMB SF RedBull | 27
 |  |  |  |  |  |  |  |  |  | 3 |  | 33073 | Red\nBull | 10
 |  |  |  |  |  |  |  |  |  | 4 |  | 330040 | [NAME] | 4
 |  |  |  |  |  |  |  |  |  | 5 |  | 27557 | Red\nBull SF | 4
 |  |  |  |  |  |  |  |  |  | 6 |  | 33000 | Coke | 4
 |  |  |  |  |  |  |  |  |  | 7 |  | 640001 | [NAME] | 1
 |  |  |  |  |  |  |  |  |  | 8 |  | 33002 | Diet\nCoke | 2
 |  |  |  |  |  |  |  |  |  | 9 |  | 33075 | Orange\nJuice | 1
 |  |  |  |  |  |  |  |  |  | 10 |  | 33076 | Cran\nJuice | 1
 |  |  |  |  |  |  |  |  |  | 11 |  | 33060 | Lemonade | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ------------
 |  |  |  |  |  |  |  |  |  |  |  |  | Tot BEVERAGES: | 89