Spreadsheet: 763698d1642328886-summarise-data-from-multiple-tables-in-dynamic-summary-table-commission
Sheet: Comm

[NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Dhruv |  |  |  |  |  |  |  | Dhruv Personal |  |  |  |  |  |  |  | Pradeep |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Hement |  |  |  |  |  |  |  | Sandeep Y190 |  |  |  |  |  |  |  | Ravi |  |  |  |  |  |  |  | Lakhan |  |  |  |  |  |  |  | VK |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Goldy |  |  |  |  |  |  |  | Nitin |  |  |  |  |  |  |  | KP |  |  |  |  |  |  |  | SN |  |  |  |  |  |  |  | Nitin X 23 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Sardar |  |  |  |  |  |  |  | Neeraj |  |  |  |  |  |  |  | Rajender |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Bablu MM |  |  |  |  |  |  |  | Sorav X55 |  |  |  |  |  |  |  | HKT |  |  |  |  |  |  |  | [NAME]
Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm IN | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm IN | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Actual Payout | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D |  | Date | RTGS IN | CASH OUT | Comm | Comm Paid | Balance | L/D
2022-01-01 00:00:00 |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 |  | 650000 |  |  |  |  |  | 2022-01-01 00:00:00 |  | 200000 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 432230 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 |  | 500000 |  |  |  |  |  | 2022-01-01 00:00:00 | 1822900 | 1815600 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-01 00:00:00 | 0 | 0 |  |  |  |  |  | 2022-01-12 00:00:00 | 840000 | 840000 |  | 1700 |  |  |  | 2022-01-01 00:00:00 | 0 | 0
 | 0 | 0 |  |  |  |  |  | 2020-07-03 00:00:00 | 25000 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 1200000 | 1200000 |  | 2400 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 2020-07-08 00:00:00 | 50000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 500000 | 500000 |  |  |  |  |  |  | 100000 | 100000 |  |  |  |  |  |  | 0 | 400000 |  |  |  |  |  |  | 462488 | 444850 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1080000 | 1075700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 1080000 |  | 2200 |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 2020-09-01 00:00:00 | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 447714 |  |  |  |  |  |  | 400000 | 400000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 2400000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1171877 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 2020-09-25 00:00:00 | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 4000000 |  |  |  |  |  |  | 598625 |  |  |  |  |  |  |  | 150000 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 450000 | 450000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2950000 |  |  |  |  |  |  | 68832 | 0 |  |  |  |  |  |  |  | 1240000 |  |  |  |  |  |  | 1000000 | 1000000 |  |  |  |  |  |  |  | 18250000 |  |  |  |  |  |  | 1000000 | 2000000 |  | 55932 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 2020-10-13 00:00:00 | 20000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2095706 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 2750000 |  | 72000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700000 | 1689300 |  |  |  |  |  |  |  | 10000000 |  | 22500 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 180000 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 1500000 |  |  |  |  |  | 2020-10-27 00:00:00 | 17000 |  |  |  |  |  |  |  |  | 3261700 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 1250000 |  | 103150 |  |  |  |  | 100000 | 100000 |  |  |  |  |  |  | 0 | 300000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 2500000 |  | 63600 |  |  |  |  |  | 4650000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 502000 | 500000 |  |  |  |  |  |  |  | 8800000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 10000000 |  |  |  |  |  |  |  | 5379000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 400000 | 0 |  |  |  |  |  | 2020-11-25 00:00:00 | 50000 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 0 | 0 |  |  |  |  |  | 2020-12-28 00:00:00 | 43500 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 5100000 |  |  |  |  |  | 2021-01-12 00:00:00 | 15000 |  |  |  |  |  |  |  |  | 1473780 |  |  |  |  |  |  | 0 | 1382000 |  |  |  |  |  |  |  | 500000 |  |  |  |  |  |  |  | 650000 |  | 22600 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 1200000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 3460000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 7500000 |  | 35900 |  |  |  |  | 1359281 | 1000000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 3200000 |  |  |  |  |  | 2021-01-22 00:00:00 | 28000 |  |  |  |  |  |  |  |  | 1736600 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 970000 |  |  |  |  |  |  |  | 650000 |  | 22600 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 3000000 |  | 106800 |  |  |  |  |  | 5800000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 9210000 |  |  |  |  |  |  | 1730000 | 1723100 |  |  |  |  |  |  |  | 10300000 |  | 22600 |  |  |  |  |  | 2000000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 800000 |  | 20300 |  |  |  |  |  | 179320 |  | 5481 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 6300000 |  |  |  |  |  | 2021-01-30 00:00:00 | 41582 |  |  |  |  |  |  |  |  | 4064300 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 1094000 |  | 38000 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 1200000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 5300000 |  |  |  |  |  |  | 1204800 | 1200000 |  |  |  |  |  |  |  | 7350000 |  |  |  |  |  |  |  | 1500000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 291121 |  | 100000 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 3000000 | 3000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 4200000 |  |  |  |  |  | 2021-02-19 00:00:00 | 25000 |  |  |  |  |  |  |  |  | 1350000 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 1000000 |  | 25400 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2300000 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 5350000 |  |  |  |  |  |  | 1200000 | 1200000 |  |  |  |  |  |  |  | 7600000 |  | 32900 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 576750 | 576750 |  | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 950000 |  | 28170 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400000 |  | 13550
 |  | 2000000 |  |  |  |  |  | 2021-03-09 00:00:00 | 25000 |  |  |  |  |  |  |  |  | 1042800 |  |  |  |  |  |  | 0 | 1762000 |  |  |  |  |  |  |  | 3450000 |  | 88500 |  |  |  |  |  | 621371 |  | 21600 |  |  |  |  | 0 | 400000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 3900000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3240000 |  |  |  |  |  |  | 752780 | 745000 |  |  |  |  |  |  |  | 8500000 |  | 18800 |  |  |  |  |  | 5000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 3000000 |  | -9000 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 2021-04-08 00:00:00 | 25000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 400000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 400000
 |  |  |  |  |  |  |  | 2021-06-16 00:00:00 | 50700 |  |  |  |  |  |  |  | 123456 | 654321
 |  |  |  |  |  |  |  | 2021-07-05 00:00:00 | 20000
 |  |  |  |  |  |  |  | 2021-07-17 00:00:00 | 20000
 |  |  |  |  |  |  |  | 2021-07-31 00:00:00 | 25000
 |  |  |  |  |  |  |  | 2021-08-10 00:00:00 | 5000
 |  |  |  |  |  |  |  | 2021-08-16 00:00:00 | 10000
 |  |  |  |  |  |  |  | 2021-09-06 00:00:00 | 50000
 |  |  |  |  |  |  |  | 2022-01-04 00:00:00 | 298444
 |  |  |  |  |  |  |  |  | 0 | 298444