Spreadsheet: 854935d1704700926-need-help-to-identify-new-customers-and-sales-by-quarter-sample-1-
Sheet: Sales

Actual Data
[NAME] | Customer | Product | Ship Date | Quantity | Value | Old | Dynamic
1 | Customer 1 | AAA | 2022-01-01 00:00:00 | 207 | 1068 |  |  |  | Total and New Products sales
2 | Customer 2 | BBB | 2022-01-17 00:00:00 | 223 | 1358 |  | New |  | Sales | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023
3 | Customer 3 | CCC | 2022-01-01 00:00:00 | 313 | 889 |  | New |  | Total |  | 18377 | 0 | 0 | 16839 | 15223 | 0 | 0
4 | Customer 4 | ABC | 2022-01-29 00:00:00 | 101 | 867 |  | New |  | New |  | 3841 | 0 | 0 | 1347 | 200 | 0 | 0
5 | Customer 5 | VCC | 2022-01-01 00:00:00 | 122 | 1366 |  | New
1 | Customer 1 | AAA | 2022-02-11 00:00:00 | 151 | 988 |  | Repeat |  | Total and New Customers
2 | Customer 2 | BBB | 2022-02-12 00:00:00 | 274 | 884 |  | Repeat |  | Sales | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023
3 | Customer 3 | CCC | 2022-02-10 00:00:00 | 164 | 1352 |  | Repeat |  | Total |  | 18377 | 0 | 0 | 16839 | 15223 | 0 | 0
4 | Customer 4 | ABC | 2022-02-05 00:00:00 | 154 | 1337 |  | Repeat |  | New |  | 555 | 0 | 0 | 0 | 200 | 0 | 0
5 | Customer 5 | VCC | 2022-02-20 00:00:00 | 282 | 881 |  | Repeat
1 | Customer 1 | AAA | 2022-03-11 00:00:00 | 330 | 930 |  | Repeat
2 | Customer 2 | BBB | 2022-03-12 00:00:00 | 369 | 1157 |  | Repeat
3 | Customer 3 | CCC | 2022-03-10 00:00:00 | 208 | 1285 |  | Repeat
4 | Customer 4 | ABC | 2022-03-05 00:00:00 | 120 | 1058 |  | Repeat
5 | Customer 5 | VCC | 2022-03-20 00:00:00 | 326 | 564 |  | Repeat
1 | Customer 1 | AAA | 2022-04-11 00:00:00 | 112 | 508 |  | Repeat
1 | Customer 1 | ABB | 2022-04-11 00:00:00 | 278 | 1049 |  | New
2 | Customer 2 | BBB | 2022-04-12 00:00:00 | 176 | 626 |  | Repeat
2 | Customer 2 | FFF | 2022-04-12 00:00:00 | 206 | 1265 |  | New
3 | Customer 3 | CCC | 2022-04-10 00:00:00 | 355 | 1480 |  | Repeat
4 | Customer 4 | ABC | 2022-04-05 00:00:00 | 137 | 1472 |  | Repeat
5 | Customer 5 | VCC | 2022-04-20 00:00:00 | 339 | 645 |  | Repeat
1 | Customer 1 | AAA | 2022-05-11 00:00:00 | 186 | 1175 |  | Repeat
11 | Customer 11 | TT.3 | 2022-05-11 00:00:00 | 186 | 555 |  | New
2 | Customer 2 | BBB | 2022-05-12 00:00:00 | 393 | 631 |  | Repeat
3 | Customer 3 | CCC | 2022-05-05 00:00:00 | 170 | 687 |  | Repeat
4 | Customer 4 | ABC | 2022-05-08 00:00:00 | 140 | 1411 |  | Repeat
5 | Customer 5 | VCC | 2022-05-17 00:00:00 | 219 | 1250 |  | Repeat
1 | Customer 1 | AAA | 2022-06-02 00:00:00 | 321 | 636 |  | Repeat
2 | Customer 2 | BBB | 2022-06-06 00:00:00 | 212 | 929 |  | Repeat
3 | Customer 3 | CCC | 2022-06-09 00:00:00 | 254 | 594 |  | Repeat
4 | Customer 4 | ABC | 2022-06-08 00:00:00 | 351 | 1080 |  | Repeat
5 | Customer 5 | VCC | 2022-06-17 00:00:00 | 327 | 1412 |  | Repeat
5 | Customer 5 | VFR | 2022-06-17 00:00:00 | 261 | 972 |  | New
1 | Customer 1 | AAA | 2023-01-01 00:00:00 | 179 | 520 |  | Repeat
1 | Customer 1 | MMM | 2023-01-01 00:00:00 | 381 | 549 |  | New
2 | Customer 2 | BBB | 2023-01-17 00:00:00 | 274 | 1201 |  | Repeat
3 | Customer 3 | CCC | 2023-01-01 00:00:00 | 250 | 699 |  | Repeat
4 | Customer 4 | ABC | 2023-01-29 00:00:00 | 292 | 1295 |  | Repeat
5 | Customer 5 | VCC | 2023-01-01 00:00:00 | 348 | 1173 |  | Repeat
1 | Customer 1 | AAA | 2023-02-11 00:00:00 | 146 | 1159 |  | Repeat
2 | Customer 2 | BBB | 2023-02-12 00:00:00 | 285 | 1228 |  | Repeat
3 | Customer 3 | CCC | 2023-02-10 00:00:00 | 332 | 799 |  | Repeat
3 | Customer 3 | PPP | 2023-02-10 00:00:00 | 269 | 798 |  | New
4 | Customer 4 | ABC | 2023-02-05 00:00:00 | 263 | 982 |  | Repeat
5 | Customer 5 | VCC | 2023-02-20 00:00:00 | 213 | 678 |  | Repeat
1 | Customer 1 | AAA | 2023-03-11 00:00:00 | 130 | 805 |  | Repeat
2 | Customer 2 | BBB | 2023-03-12 00:00:00 | 176 | 1470 |  | Repeat
3 | Customer 3 | CCC | 2023-03-10 00:00:00 | 152 | 1232 |  | Repeat
4 | Customer 4 | ABC | 2023-03-05 00:00:00 | 143 | 902 |  | Repeat
5 | Customer 5 | VCC | 2023-03-20 00:00:00 | 202 | 1349 |  | Repeat
1 | Customer 1 | AAA | 2023-04-11 00:00:00 | 177 | 591 |  | Repeat
2 | Customer 2 | BBB | 2023-04-12 00:00:00 | 301 | 1366 |  | Repeat
3 | Customer 3 | CCC | 2023-04-10 00:00:00 | 226 | 1360 |  | Repeat
4 | Customer 4 | ABC | 2023-04-05 00:00:00 | 271 | 1419 |  | Repeat
5 | Customer 5 | VCC | 2023-04-20 00:00:00 | 320 | 833 |  | Repeat
1 | Customer 1 | AAA | 2023-05-11 00:00:00 | 368 | 887 |  | Repeat
2 | Customer 2 | BBB | 2023-05-12 00:00:00 | 133 | 504 |  | Repeat
3 | Customer 3 | CCC | 2023-05-05 00:00:00 | 378 | 1099 |  | Repeat
4 | Customer 4 | ABC | 2023-05-08 00:00:00 | 369 | 631 |  | Repeat
5 | Customer 5 | VCC | 2023-05-17 00:00:00 | 348 | 660 |  | Repeat
1 | Customer 1 | AAA | 2023-06-02 00:00:00 | 369 | 594 |  | Repeat
2 | Customer 2 | BBB | 2023-06-06 00:00:00 | 387 | 1139 |  | Repeat
3 | Customer 3 | CCC | 2023-06-09 00:00:00 | 185 | 1242 |  | Repeat
4 | Customer 4 | ABC | 2023-06-08 00:00:00 | 235 | 924 |  | Repeat
5 | Customer 5 | VCC | 2023-06-17 00:00:00 | 267 | 1055 |  | Repeat
5 | Customer 5 | VFR | 2023-06-17 00:00:00 | 138 | 719 |  | Repeat
55 | Customer 55 | ABCD | 2023-06-17 00:00:00 | 138 | 200 |  | New