Spreadsheet: 782899d1654396903-using-formula-to-display-top-20-items-to-excel-forum
Sheet: PivotTable

Outlet | Blue Lagoon
Month | (All)
Item | Family Group | Major Group | Qty | NTD
FISH HEAD ND SP | BL RICE & NDLS | FOOD | 596 | 194277
CKT | BL RICE & NDLS | FOOD | 595 | 194162
MJNG RNT 2H WTEA | HOT & COLD BEVERAGES | BEVERAGE | 383 | 176180
HAINAN CHIX RICE | BL RICE & NDLS | FOOD | 478 | 155749
BL NASI GORENG W SATAY | BL RICE & NDLS | FOOD | 555 | 154317
SFD HORFUN | BL RICE & NDLS | FOOD | 442 | 144142
BLBAHKUTTEH | BL RICE & NDLS | FOOD | 420 | 136340
CURRY LAKSA | BL RICE & NDLS | FOOD | 404 | 131873
[NAME] | BL SNACKS | FOOD | 468 | 129483
NTD 200 3 ITEMS | BL SUPPER MENU | FOOD | 730 | 123370
STIR FRIED VEGE | BL VEG | FOOD | 580 | 114250
WANTON NDL DRY | BL RICE & NDLS | FOOD | 324 | 105972
HOKKIEN MEE | BL RICE & NDLS | FOOD | 363 | 101292
MJNG RNT ADD | HOT & COLD BEVERAGES | BEVERAGE | 547 | 87520
SICHUAN CHIX | BL POULTRY MENU | FOOD | 290 | 80025
BL PRAWN OMELETE | BL SEAFOOD MENU | FOOD | 332 | 79326
PR BEER BKT 5 | BEER PROMO | BEVERAGE | 133 | 78869
SD COKE | SOFTDRINKS | BEVERAGE | 519 | 71274
TW CHIX SOUP | BL SOUP | FOOD | 730 | 71035
BL YAM CONEE | BL RICE & NDLS | FOOD | 359 | 70708
[NAME] | BL RICE & NDLS | FOOD | 191 | 62517
NASI LEMAK | BL RICE & NDLS | FOOD | 189 | 55192
BL CLPOT CHIX SF | BL RICE & NDLS | FOOD | 153 | 51680
CLUB SANDWICH | BL BRGS & SNDWCH | FOOD | 177 | 48999
FRUIT PLATTER | BL DESSERT | FOOD | 622 | 48445
BL TW BF NDL SUP | BL RICE & NDLS | FOOD | 102 | 47029
TW PORK BENTO | BL MEAT MENU | FOOD | 133 | 43493
BL SP CHIC WING | BL SUPPER MENU | FOOD | 427 | 41826
BL DF WANTON DUM | BL SNACKS | FOOD | 188 | 41288
VIET BEEF NOODLE | BL RICE & NDLS | FOOD | 229 | 41065
PERRIER 330ML | MINERAL WATER | BEVERAGE | 244 | 40992
HONEY CHICKEN | BL POULTRY MENU | FOOD | 122 | 39705
BL PRSVDOLIVERIC | BL RICE & NDLS | FOOD | 118 | 38671
BANANA SPLIT | BL DESSERT | FOOD | 199 | 37229
KAYA TOAST | BL SET MENU | FOOD | 217 | 36456
I/C SINGLE SCOOP | BL DESSERT | FOOD | 484 | 32839
BL SP FS BALL ND | BL SUPPER MENU | FOOD | 334 | 32722
SP BEEF NDL SOUP | BL SUPPER MENU | FOOD | 332 | 32461
+C LEMON SODA | SOFTDRINKS | BEVERAGE | 232 | 31999
BL SPCY SMH CHIX | BL RICE & NDLS | FOOD | 113 | 31465
SFD FRIED MEEHON | BL RICE & NDLS | FOOD | 95 | 31111
BL SP SH DUMPLIN | BL SUPPER MENU | FOOD | 301 | 29448
BL BR PRWN PORK | BL RICE & NDLS | FOOD | 102 | 29302
BL BR CHIX BLEAF | BL POULTRY MENU | FOOD | 92 | 26212
SD COKE ZERO | SOFTDRINKS | BEVERAGE | 186 | 25652
SP MEE GORENG | BL SUPPER MENU | FOOD | 250 | 24481
BL BCN BEANCURD | BL VEG | FOOD | 84 | 23965
HEINEKEN BTL | BEER/STOUT | BEVERAGE | 126 | 23637
BL SEAFD CURY NO | BL RICE & NDLS | FOOD | 80 | 23006
SAN PELLGNO 750 | MINERAL WATER | BEVERAGE | 108 | 22464
SD SPRITE | SOFTDRINKS | BEVERAGE | 160 | 21987
CORONA BTL | BEER/STOUT | BEVERAGE | 112 | 20914
HERBAL TEA | HOT&COLD BEV PRO | BEVERAGE | 266 | 20748
SP CROQUE MONSIE | BL SUPPER MENU | FOOD | 211 | 20663
SP CONGEE CHAIPOH | BL SUPPER MENU | FOOD | 207 | 20256
SATAY CHICKEN | BL POULTRY MENU | FOOD | 61 | 19927
BL OKWA BRIS NOO | BL RICE & NDLS | FOOD | 47 | 19625
SD GINGER ALE | SOFTDRINKS | BEVERAGE | 133 | 18354
BL FRN PR ANGEL | BL SEAFOOD MENU | FOOD | 70 | 18200
SD ORANGE CRUSH | SOFTDRINKS | BEVERAGE | 121 | 16613
SHANGHAI DUMPLIN | BL SNACKS | FOOD | 72 | 16416
CAFFE AMERICANO | HOT & COLD BEVERAGES | BEVERAGE | 106 | 14600
SP ANCH FRD RICE | BL SUPPER MENU | FOOD | 149 | 14593
CAFE LATTE | HOT & COLD BEVERAGES | BEVERAGE | 88 | 13883
AMERICAN BFAST | BL SET MENU | FOOD | 47 | 13536
TW MNCD PORK | BL RICE & NDLS | FOOD | 137 | 13378
FRIED EGG | BL SIDE DISH | FOOD | 333 | 12646
BL OKWA STIR BEF | BL MEAT MENU | FOOD | 22 | 11254
FR RED APPLE GLS | JUICE FRESH | BEVERAGE | 58 | 9699
FR ORANGE GLS | JUICE FRESH | BEVERAGE | 56 | 9408
HH 1+1 BEER | BEER PROMO | BEVERAGE | 45 | 8460
CAKE 1KG | MICE FOOD | FOOD | 5 | 7750
EVIAN 500ML | MINERAL WATER | BEVERAGE | 46 | 7711
ASIAN BFAST | BL SET MENU | FOOD | 25 | 7171
CM CURRY LAKSA | BL RICE & NDLS | FOOD | 45 | 6750
OMELETE | BL SIDE DISH | FOOD | 84 | 6552
BL DRUNKEN CHIX | BL POULTRY MENU | FOOD | 36 | 6480
CM CKT | BL RICE & NDLS | FOOD | 43 | 6450
MEVIUS SKYBLUE | CIGARETTES | TOBACCO | 32 | 6240
BL CNY PORK BALL | BL MEAT MENU | FOOD | 16 | 5888
BUDWEISER BTL | BEER/STOUT | BEVERAGE | 31 | 5805
SPRING CHICKEN | BL SEAFOOD MENU | FOOD | 13 | 5590
CM PIZZA CARBONA | MP PIE & PIZZA | FOOD | 37 | 5550
MEVIUS ORIGINAL | CIGARETTES | TOBACCO | 28 | 5460
SD SODA WATER | SOFTDRINKS | BEVERAGE | 38 | 5244
FR WATERMELN GLS | JUICE FRESH | BEVERAGE | 30 | 5040
FRENCH FRIES | BL SNACKS | FOOD | 23 | 4544
CM CHIX BENTO | BL RICE & NDLS | FOOD | 25 | 4500
CM YC FRIED RICE | BL RICE & NDLS | FOOD | 36 | 4320
[NAME] | BEER/STOUT | BEVERAGE | 23 | 4290
CM PIZZA PEPPE | MP PIE & PIZZA | FOOD | 16 | 4160
BL FR EGG ND LBT | BL SEAFOOD MENU | FOOD | 6 | 4080
CM BKT | BL RICE & NDLS | FOOD | 22 | 3960
CAPPUCCINO | HOT & COLD BEVERAGES | BEVERAGE | 24 | 3792
PLAIN RICE | BL SIDE DISH | FOOD | 100 | 3792
TAIWAN GOLD BEER | BEER/STOUT | BEVERAGE | 20 | 3760
TIGER BEER CAN | BEER/STOUT | BEVERAGE | 18 | 3384
GUINESS CAN 440M | BEER/STOUT | BEVERAGE | 15 | 3091
GLENMORANGIE BTL | WHISKY | BEVERAGE | 1 | 2888
CM SFD HORFUN | BL RICE & NDLS | FOOD | 19 | 2850
BL DF CHIX W KCI | BL POULTRY MENU | FOOD | 10 | 2800
S PELLGRINO 1 LTR | MINERAL WATER | BEVERAGE | 13 | 2704
CM HAINAN CHIX | BL RICE & NDLS | FOOD | 17 | 2550
SPL WINE PK 5 BTL | PACKAGES | BEVERAGE | 1 | 2542
BIRTHDAYPACKAGE | MICE BEVERAGE | BEVERAGE | 1 | 2380
FR GRN APPLE GLS | JUICE FRESH | BEVERAGE | 14 | 2352
CM PIZZA PORK CS | MP PIE & PIZZA | FOOD | 9 | 2340
CM CHIX WING | BL SNACKS | FOOD | 19 | 2280
CM PIZZA MARGA | MP PIE & PIZZA | FOOD | 12 | 2160
CM CHEESY FFRIES | BL SNACKS | FOOD | 26 | 2080
CARLSBERG BTL | BEER/STOUT | BEVERAGE | 11 | 2068
CM SD C LEMON | SOFTDRINKS | BEVERAGE | 36 | 1800
CM SD COKE | SOFTDRINKS | BEVERAGE | 35 | 1750
KIDSBDAYPACKGE | MICE BEVERAGE | BEVERAGE | 1 | 1660
CM FISH HEAD NDL | BL RICE & NDLS | FOOD | 9 | 1620
CM PORK BENTO | BL RICE & NDLS | FOOD | 9 | 1440
TAIHU FRM LEMON | BEER PROMO | BEVERAGE | 7 | 1247
SD TONIC WATER | SOFTDRINKS | BEVERAGE | 9 | 1222
MARLBORO LIGHT | CIGARETTES | TOBACCO | 6 | 1170
CM CREME CARAMEL | MP [NAME] | FOOD | 23 | 1150
CM SD OANGE CRUSH | SOFTDRINKS | BEVERAGE | 21 | 1050
CAKE HALF KG | MICE FOOD | FOOD | 1 | 1050
CM MATCHA ICE CR | MI DESSERT | FOOD | 19 | 950
WR LINDEMANS 45 | AUSTRALIAN RED | BEVERAGE | 1 | 888
ADD [NAME] | BL ADD ONS | FOOD | 45 | 810
TIGER PRAWN MILK | BL SEAFOOD MENU | FOOD | 2 | 737
BL SF LBT 3 CASU | BL SEAFOOD MENU | FOOD | 1 | 680
CM SD GINGER ALE | SOFTDRINKS | BEVERAGE | 13 | 650
CM SD SPRITE | SOFTDRINKS | BEVERAGE | 12 | 600
ADD LUNCHEON MT | BL ADD ONS | FOOD | 10 | 600
BEER ASAHI BTL | BEER/STOUT | BEVERAGE | 3 | 564
FR RED APPLE JUG | JUICE FRESH | BEVERAGE | 1 | 508
HERBAL TEA GLS | HOT & COLD BEVERAGES | BEVERAGE | 4 | 432
CM CHIX SOUP | BL SOUP | FOOD | 4 | 392
MARLBORO RED | CIGARETTES | TOBACCO | 2 | 390
MARLBORO MENTHO | CIGARETTES | TOBACCO | 2 | 390
JASMINE TEA | HOT & COLD BEVERAGES | BEVERAGE | 3 | 384
CM SD COKE ZERO | SOFTDRINKS | BEVERAGE | 7 | 350
LATTE MACHIATO | HOT & COLD BEVERAGES | BEVERAGE | 2 | 316
GREENTEA | HOT & COLD BEVERAGES | BEVERAGE | 2 | 256
EARL GREY TEA | HOT & COLD BEVERAGES | BEVERAGE | 2 | 256
CS AMERICAN BFAST | BL SET MENU | FOOD | 1 | 168
DBL ESPRESSO | HOT & COLD BEVERAGES | BEVERAGE | 1 | 158
BL SP CONGEE | BL SUPPER MENU | FOOD | 2 | 156
CHILED PINEAPPLE | JUICE CONCENT | BEVERAGE | 1 | 138
SD COME BEST | SOFTDRINKS | BEVERAGE | 1 | 138
CHILED ORANGE | JUICE CONCENT | BEVERAGE | 1 | 138
ESPRESSO | HOT & COLD BEVERAGES | BEVERAGE | 1 | 138
CM SAN PELLGNO | MINERAL WATER | BEVERAGE | 1 | 130
ENGLISH BKFS TEA | HOT & COLD BEVERAGES | BEVERAGE | 1 | 128
ADD NDL | BL ADD ONS | FOOD | 7 | 126
ADD SATAY SAUCE | BL ADD ONS | FOOD | 2 | 120
Grand Total |  |  | 19280 | 4030873