Spreadsheet: 100694d1298982752-sort-out-the-multiple-occurrence-and-sum-up-the-value-test-1-v2
Sheet: Sheet1

Member No | Member [NAME] | Check # | Date | Outlet | Pax | Loyalty Code | Total Spend |  |  | Using Page Fields |  |  |  | Using Additional Row Fields
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 |  |  | Date | Jul
V121684 | Dang Trung Quoc | 20016411 | 2010-06-05 00:00:00 | American Discotheque | 0 | POS-STD | 620730 |  |  | Years | 2010
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 |  |  | Sum of Total Spend |  |  |  | Sum of Total Spend
V121684 | Dang Trung Quoc | 20016594 | 2010-06-12 00:00:00 | American Discotheque | 0 | POS-STD | 542685 |  |  | Member No | Total |  |  | Year | Month | Member No | Total
V121684 | Dang Trung Quoc | 20016658 | 2011-06-14 00:00:00 | American Discotheque | 0 | POS-STD | 1686740 |  |  | [NAME] | 3816945 |  |  | 2010 | Jun | V108455 | 1145265
V121684 | Dang Trung Quoc | 20016675 | 2010-06-15 00:00:00 | American Discotheque | 0 | POS-STD | 402930 |  |  | V120006 | 288585 |  |  |  |  | V119286 | 468270
V121684 | Dang Trung Quoc | 20016811 | 2010-06-22 00:00:00 | American Discotheque | 0 | POS-STD | 566280 |  |  | V120974 | 1382425 |  |  |  |  | V120006 | 2727945
V121684 | Dang Trung Quoc | 20016936 | 2011-06-27 00:00:00 | American Discotheque | 0 | POS-STD | 686070 |  |  | V125674 | 359370 |  |  |  |  | V120974 | 2027355
V121684 | Dang Trung Quoc | 20016962 | 2010-06-28 00:00:00 | American Discotheque | 0 | POS-STD | 1006720 |  |  | Grand Total | 5847325 |  |  |  |  | V121684 | 6007045
V121684 | Dang Trung Quoc | 20016986 | 2010-06-29 00:00:00 | American Discotheque | 0 | POS-STD | 602580 |  |  |  |  |  |  |  |  | [NAME] | 4305785
V119286 | Deverajah Sundarraj | 20016768 | 2010-06-20 00:00:00 | American Discotheque | 0 | POS-STD | 468270 |  |  |  |  |  |  |  |  | V125674 | 228690
V108455 | Do [NAME] | 20016406 | 2011-06-05 00:00:00 | American Discotheque | 0 | POS-STD | 4858755 |  |  |  |  |  |  |  | Jul | [NAME] | 3816945
V108455 | Do [NAME] | 20016619 | 2010-06-13 00:00:00 | American Discotheque | 10 | POS-STD | 1145265 |  |  |  |  |  |  |  |  | V120006 | 288585
[NAME] | [NAME] | 20016479 | 2010-06-07 00:00:00 | American Discotheque | 0 | POS-STD | 2024330 |  |  |  |  |  |  |  |  | V120974 | 1382425
[NAME] | [NAME] | 20016797 | 2010-06-21 00:00:00 | American Discotheque | 0 | POS-STD | 2281455 |  |  |  |  |  |  |  |  | V125674 | 359370
V125674 | Ha Kiet Nguyen | 21014598 | 2010-06-12 00:00:00 | American Discotheque | 0 | POS-STD | 228690 |  |  |  |  |  |  | 2011 | Jun | V108455 | 4858755
V125674 | Ha Kiet Nguyen | 23017472 | 2010-07-27 00:00:00 | American Discotheque | 0 | POS-STD | 359370 |  |  |  |  |  |  |  |  | V121684 | 2372810
V120974 | [NAME] | 20016360 | 2010-06-03 00:00:00 | American Discotheque | 6 | POS-STD | 451935 |  |  |  |  |  |  |  | Jul | V120006 | 228690
V120974 | [NAME] | 20016456 | 2010-07-06 00:00:00 | American Discotheque | 0 | POS-STD | 1382425 |  |  |  |  |  |  | Grand Total |  |  | 30217935
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-07-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-07-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 | 2011-07-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