Spreadsheet: 100646d1298952374-sort-out-the-multiple-occurrence-and-sum-up-the-value-test-1
Sheet: Sheet1

Member No | Member [NAME] | Check # | Date | Outlet | Pax | Loyalty Code | Total Spend
V121684 | Dang Trung Quoc | 20016301 | 2010-06-01 00:00:00 | American Discotheque | 0 | POS-STD | 1056330
V121684 | Dang Trung Quoc | 20016392 | 2010-06-04 00:00:00 | American Discotheque | 0 | POS-STD | 179685
V121684 | Dang Trung Quoc | 20016411 | 2010-06-05 00:00:00 | American Discotheque | 0 | POS-STD | 620730
V121684 | Dang Trung Quoc | 21014557 | 2010-06-06 00:00:00 | American Discotheque | 0 | POS-STD | 588060
V121684 | Dang Trung Quoc | 20016571 | 2010-06-11 00:00:00 | American Discotheque | 3 | POS-STD | 441045
V121684 | Dang Trung Quoc | 20016594 | 2010-06-12 00:00:00 | American Discotheque | 0 | POS-STD | 542685
V121684 | Dang Trung Quoc | 20016658 | 2010-06-14 00:00:00 | American Discotheque | 0 | POS-STD | 1686740
V121684 | Dang Trung Quoc | 20016675 | 2010-06-15 00:00:00 | American Discotheque | 0 | POS-STD | 402930
V121684 | Dang Trung Quoc | 20016811 | 2010-06-22 00:00:00 | American Discotheque | 0 | POS-STD | 566280
V121684 | Dang Trung Quoc | 20016936 | 2010-06-27 00:00:00 | American Discotheque | 0 | POS-STD | 686070
V121684 | Dang Trung Quoc | 20016962 | 2010-06-28 00:00:00 | American Discotheque | 0 | POS-STD | 1006720
V121684 | Dang Trung Quoc | 20016986 | 2010-06-29 00:00:00 | American Discotheque | 0 | POS-STD | 602580
V119286 | Deverajah Sundarraj | 20016768 | 2010-06-20 00:00:00 | American Discotheque | 0 | POS-STD | 468270
V108455 | Do [NAME] | 20016406 | 2010-06-05 00:00:00 | American Discotheque | 0 | POS-STD | 4858755
V108455 | Do [NAME] | 20016619 | 2010-06-13 00:00:00 | American Discotheque | 10 | POS-STD | 1145265
[NAME] | [NAME] | 20016479 | 2010-06-07 00:00:00 | American Discotheque | 0 | POS-STD | 2024330
[NAME] | [NAME] | 20016797 | 2010-06-21 00:00:00 | American Discotheque | 0 | POS-STD | 2281455
V125674 | Ha Kiet Nguyen | 21014598 | 2010-06-12 00:00:00 | American Discotheque | 0 | POS-STD | 228690
V125674 | Ha Kiet Nguyen | 23017472 | 2010-06-27 00:00:00 | American Discotheque | 0 | POS-STD | 359370
V120974 | [NAME] | 20016360 | 2010-06-03 00:00:00 | American Discotheque | 6 | POS-STD | 451935
V120974 | [NAME] | 20016456 | 2010-06-06 00:00:00 | American Discotheque | 0 | POS-STD | 1382425
V120974 | [NAME] | 20016622 | 2010-06-13 00:00:00 | American Discotheque | 2 | POS-STD | 430155
V120974 | [NAME] | 20016772 | 2010-06-20 00:00:00 | American Discotheque | 0 | POS-STD | 1145265
[NAME] | [NAME] | 23017234 | 2010-06-13 00:00:00 | American Discotheque | 0 | POS-STD | 3816945
V120006 | [NAME] | 23016931 | 2010-06-01 00:00:00 | American Discotheque | 0 | POS-STD | 168795
V120006 | [NAME] | 23016953 | 2010-06-02 00:00:00 | American Discotheque | 0 | POS-STD | 1698840
V120006 | [NAME] | 23016977 | 2010-06-03 00:00:00 | American Discotheque | 0 | POS-STD | 288585
V120006 | [NAME] | 23016996 | 2010-06-04 00:00:00 | American Discotheque | 0 | POS-STD | 511830
V120006 | [NAME] | 23017016 | 2010-06-05 00:00:00 | American Discotheque | 0 | POS-STD | 228690
V120006 | [NAME] | 20016504 | 2010-06-08 00:00:00 | American Discotheque | 0 | POS-STD | 228690
V120006 | [NAME] | 20016531 | 2010-06-09 00:00:00 | American Discotheque | 2 | POS-STD | 119790