Spreadsheet: 804032d1667851935-sum-of-maximum-value-based-on-unique-sales-man-sample-final
Sheet: PolicyData

Policy | Date | Premium | Sales Man # | Revenue | Premium Sum
100242 | 2021-01-02 00:00:00 | 180 | A1001 | 50 | 0
100242 | 2021-01-02 00:00:00 | 20 | A1001 | 5 | 0 | 0
100242 | 2021-01-02 00:00:00 | 250 | A1003 | 0 | 0 | 0
100242 | 2021-01-02 00:00:00 | 48 | A1003 | 10 | 0 | 0
100242 | 2021-01-02 00:00:00 | 750 | A1009 | 100 | 0 | 0
100242 | 2021-01-02 00:00:00 | 450 | A1009 | 50 | 0 | 0
100242 | 2021-01-02 00:00:00 | 900 | A1015 | -250 | 0 | 0
100242 | 2021-01-02 00:00:00 | 250 | A1015 | 10 | 0 | 0
100242 | 2021-01-05 00:00:00 | 180 | A1001 | 50 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 20 | A1001 | 5 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 250 | A1003 | 0 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 48 | A1003 | 10 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 750 | A1009 | 100 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 450 | A1009 | 50 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 900 | A1015 | 250 | 2080 | 2080
100242 | 2021-01-05 00:00:00 | 250 | A1015 | 10 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 180 | A1001 | 50 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 20 | A1001 | 5 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 250 | A1003 | 0 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 48 | A1003 | 10 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 750 | A1009 | 100 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 450 | A1009 | 50 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 900 | A1015 | 300 | 2080 | 2080
100242 | 2021-01-09 00:00:00 | 250 | A1015 | 10 | 2080 | 2080
100257 | 2021-01-02 00:00:00 | 180 | A1001 | 50
100257 | 2021-01-02 00:00:00 | 20 | A1001 | 5
100257 | 2021-01-02 00:00:00 | 250 | A1003 | 0
100257 | 2021-01-02 00:00:00 | 48 | A1003 | 10
100257 | 2021-01-02 00:00:00 | 750 | A1009 | 100
100257 | 2021-01-02 00:00:00 | 450 | A1009 | 50
100257 | 2021-01-02 00:00:00 | 900 | A1015 | 200
100257 | 2021-01-05 00:00:00 | 180 | A1001 | 50
100257 | 2021-01-05 00:00:00 | 20 | A1001 | 5
100257 | 2021-01-05 00:00:00 | 250 | A1003 | 0
100257 | 2021-01-05 00:00:00 | 48 | A1003 | 10
100257 | 2021-01-05 00:00:00 | 450 | A1009 | 50
100257 | 2021-01-05 00:00:00 | 900 | A1015 | 250
100257 | 2021-01-05 00:00:00 | 250 | A1015 | 10
100257 | 2021-01-09 00:00:00 | 180 | A1001 | 50
100257 | 2021-01-09 00:00:00 | 48 | A1003 | 10
100257 | 2021-01-09 00:00:00 | 750 | A1009 | 100
100257 | 2021-01-09 00:00:00 | 450 | A1009 | 50
100257 | 2021-01-09 00:00:00 | 900 | A1015 | 300
100257 | 2021-01-09 00:00:00 | 250 | A1015 | 10
100689 | 2021-01-02 00:00:00 | 180 | A1001 | 50
100689 | 2021-01-02 00:00:00 | 20 | A1001 | 5
100689 | 2021-01-02 00:00:00 | 250 | A1003 | 0
100689 | 2021-01-02 00:00:00 | 48 | A1003 | 10
100689 | 2021-01-02 00:00:00 | 750 | A1009 | 100
100689 | 2021-01-02 00:00:00 | 450 | A1009 | 50
100689 | 2021-01-02 00:00:00 | 900 | A1015 | -250
100689 | 2021-01-02 00:00:00 | 250 | A1015 | 10
100689 | 2021-01-05 00:00:00 | 180 | A1001 | 50
100689 | 2021-01-05 00:00:00 | 20 | A1001 | 5
100689 | 2021-01-05 00:00:00 | 250 | A1003 | 0
100689 | 2021-01-05 00:00:00 | 48 | A1003 | 10
100689 | 2021-01-05 00:00:00 | 750 | A1009 | 100
100689 | 2021-01-05 00:00:00 | 450 | A1009 | 50
100689 | 2021-01-05 00:00:00 | 900 | A1015 | 250
100689 | 2021-01-05 00:00:00 | 250 | A1015 | 10
100689 | 2021-01-09 00:00:00 | 180 | A1001 | 50
100689 | 2021-01-09 00:00:00 | 20 | A1001 | 5
100689 | 2021-01-09 00:00:00 | 250 | A1003 | 0
100689 | 2021-01-09 00:00:00 | 48 | A1003 | 10
100689 | 2021-01-09 00:00:00 | 750 | A1009 | 100
100689 | 2021-01-09 00:00:00 | 450 | A1009 | 50
100689 | 2021-01-09 00:00:00 | 900 | A1015 | 300
100689 | 2021-01-09 00:00:00 | 250 | A1015 | 10
100879 | 2021-01-02 00:00:00 | 180 | A1001 | 50
100879 | 2021-01-02 00:00:00 | 20 | A1001 | 5
100879 | 2021-01-02 00:00:00 | 250 | A1003 | 0
100879 | 2021-01-02 00:00:00 | 48 | A1003 | 10
100879 | 2021-01-02 00:00:00 | 750 | A1009 | 100
100879 | 2021-01-02 00:00:00 | 450 | A1009 | 50
100879 | 2021-01-05 00:00:00 | 250 | A1003 | 0
100879 | 2021-01-05 00:00:00 | 48 | A1003 | 10
100879 | 2021-01-05 00:00:00 | 750 | A1009 | 100
100879 | 2021-01-05 00:00:00 | 450 | A1009 | 50
100879 | 2021-01-05 00:00:00 | 900 | A1015 | 250
100879 | 2021-01-05 00:00:00 | 250 | A1015 | 10
100879 | 2021-01-09 00:00:00 | 180 | A1001 | 50
100879 | 2021-01-09 00:00:00 | 20 | A1001 | 5
100879 | 2021-01-09 00:00:00 | 250 | A1003 | 0
100879 | 2021-01-09 00:00:00 | 48 | A1003 | 10
100879 | 2021-01-09 00:00:00 | 750 | A1009 | 100
100879 | 2021-01-09 00:00:00 | 450 | A1009 | 50
100879 | 2021-01-09 00:00:00 | 900 | A1015 | 300
100879 | 2021-01-09 00:00:00 | 250 | A1015 | 10
110548 | 2021-01-02 00:00:00 | 180 | A1001 | 50
110548 | 2021-01-02 00:00:00 | 20 | A1001 | 5
110548 | 2021-01-02 00:00:00 | 250 | A1003 | 0
110548 | 2021-01-02 00:00:00 | 48 | A1003 | 10
110548 | 2021-01-02 00:00:00 | 750 | A1009 | 100
110548 | 2021-01-02 00:00:00 | 450 | A1009 | 50
110548 | 2021-01-02 00:00:00 | 900 | A1015 | -250
110548 | 2021-01-02 00:00:00 | 250 | A1015 | 10
110548 | 2021-01-05 00:00:00 | 180 | A1001 | 50
110548 | 2021-01-05 00:00:00 | 20 | A1001 | 5
110548 | 2021-01-05 00:00:00 | 250 | A1003 | 0
110548 | 2021-01-05 00:00:00 | 48 | A1003 | 10
110548 | 2021-01-05 00:00:00 | 750 | A1009 | 100
110548 | 2021-01-05 00:00:00 | 450 | A1009 | 50
110548 | 2021-01-05 00:00:00 | 900 | A1015 | 250
110548 | 2021-01-05 00:00:00 | 250 | A1015 | 10
110548 | 2021-01-09 00:00:00 | 180 | A1001 | 50
110548 | 2021-01-09 00:00:00 | 20 | A1001 | 5
110548 | 2021-01-09 00:00:00 | 250 | A1003 | 0
110548 | 2021-01-09 00:00:00 | 48 | A1003 | 10
110548 | 2021-01-09 00:00:00 | 750 | A1009 | 100
110548 | 2021-01-09 00:00:00 | 450 | A1009 | 50
110548 | 2021-01-09 00:00:00 | 900 | A1015 | 300
110548 | 2021-01-09 00:00:00 | 250 | A1015 | 10
125478 | 2021-01-02 00:00:00 | 180 | A1001 | 50
125478 | 2021-01-02 00:00:00 | 20 | A1001 | 5
125478 | 2021-01-02 00:00:00 | 250 | A1003 | 0
125478 | 2021-01-02 00:00:00 | 48 | A1003 | 10
125478 | 2021-01-02 00:00:00 | 750 | A1009 | 100
125478 | 2021-01-02 00:00:00 | 450 | A1009 | 50
125478 | 2021-01-02 00:00:00 | 900 | A1015 | -250
125478 | 2021-01-02 00:00:00 | 250 | A1015 | 10
125478 | 2021-01-05 00:00:00 | 180 | A1001 | 50
125478 | 2021-01-05 00:00:00 | 20 | A1001 | 5
125478 | 2021-01-05 00:00:00 | 250 | A1003 | 0
125478 | 2021-01-05 00:00:00 | 48 | A1003 | 10
125478 | 2021-01-05 00:00:00 | 750 | A1009 | 100
125478 | 2021-01-05 00:00:00 | 450 | A1009 | 50
125478 | 2021-01-05 00:00:00 | 900 | A1015 | 250
125478 | 2021-01-05 00:00:00 | 250 | A1015 | 10
125478 | 2021-01-09 00:00:00 | 180 | A1001 | 50
125478 | 2021-01-09 00:00:00 | 20 | A1001 | 5
125478 | 2021-01-09 00:00:00 | 250 | A1003 | 0
125478 | 2021-01-09 00:00:00 | 48 | A1003 | 10
125478 | 2021-01-09 00:00:00 | 750 | A1009 | 100
125478 | 2021-01-09 00:00:00 | 450 | A1009 | 50
125478 | 2021-01-09 00:00:00 | 900 | A1015 | 300
125478 | 2021-01-09 00:00:00 | 250 | A1015 | 10