Spreadsheet: 290272d1389826160-data-challenge-turning-massive-amounts-of-sales-order-data-into-summarized-customer-data-eforum-example2
Sheet: Data

Account | Sales Orders | Net Sales
100000 | Total | 1827.63
100000 | SO-1346450 | 292.62
100000 | SO-1671557 | 990.84
100000 | SO-1744401 | 544.17
100005 | Total | 6868.1
100005 | SO-1251183 | 572.01
100005 | SO-1348546 | 252.91
100005 | SO-1361448 | 287.21
100005 | SO-1367080 | 241.76
100005 | SO-1380111 | 418.14
100005 | SO-1510861 | 283.32
100005 | SO-1530250 | 35.85
100005 | SO-1543553 | 579.17
100005 | SO-1550212 | -11.95
100005 | SO-1553796 | 138.75
100005 | SO-1562380 | 213.34
100005 | SO-1564726 | 418.72
100005 | SO-1585660 | 541.55
100005 | SO-1588637 | 145.31
100005 | SO-1599173 | 903.93
100005 | SO-1735918 | 231
100005 | SO-1801910 | 763.45
100005 | SO-1817581 | 514.37
100005 | SO-1821287 | 339.26
100010 | Total | 70032.42
100010 | SO-1190343 | 332.7
100010 | SO-1196675 | 244.85
100010 | SO-1206620 | 305.25
100010 | SO-1207179 | 27.4
100010 | SO-1211869 | 68.5
100010 | SO-1220126 | 132.55
100010 | SO-1228185 | 137.05
100010 | SO-1236216 | 211.26
100010 | SO-1249241 | 54.75
100010 | SO-1258479 | 120.5
100010 | SO-1263749 | 619.6
100010 | SO-1265995 | 196.1
100010 | SO-1268091 | 142.6
100010 | SO-1270502 | 152.9
100010 | SO-1273730 | 76.45
100010 | SO-1281052 | 236.5
100010 | SO-1282756 | 410.6
100010 | SO-1285538 | 172.75
100010 | SO-1290904 | 733.6
100010 | SO-1294806 | 304
100010 | SO-1294816 | 419.7
100010 | SO-1302097 | 126.4
100010 | SO-1302766 | 118.5
100010 | SO-1311441 | 347.65
100010 | SO-1316087 | 307.45
100010 | SO-1317370 | 401.55
100010 | SO-1318942 | 116.3
100010 | SO-1325094 | 296.8
100010 | SO-1326536 | 286.8
100010 | SO-1333021 | 319.35
100010 | SO-1337941 | 240.7
100010 | SO-1340406 | 257.85
100010 | SO-1342243 | 356.3
100010 | SO-1345131 | 315.45
100010 | SO-1348013 | 154.45
100010 | SO-1348609 | 520.65
100010 | SO-1350863 | 74.25
100010 | SO-1356293 | 320.05
100010 | SO-1360682 | 0
100010 | SO-1362012 | 525.25
100010 | SO-1362828 | 371.9
100010 | SO-1364731 | 804.5
100010 | SO-1367476 | 304.3
100010 | SO-1368901 | 307
100010 | SO-1372403 | 454.6
100010 | SO-1374409 | 1076.3
100010 | SO-1375403 | 446
100010 | SO-1376708 | 1240.2
100010 | SO-1377442 | 1275.7
100010 | SO-1378744 | 542.7
100010 | SO-1378929 | -238.8
100010 | SO-1379773 | 156.3
100010 | SO-1379784 | 397.7
100010 | SO-1381530 | -226.8
100010 | SO-1381725 | 387
100010 | SO-1382391 | 331.9
100010 | SO-1383316 | 520.1
100010 | SO-1385766 | 485.5
100010 | SO-1386685 | 361.8
100010 | SO-1389450 | 702.2
100010 | SO-1392550 | 1145
100010 | SO-1394925 | 344.4
100010 | SO-1395720 | 138.6
100010 | SO-1396761 | 238.2
100010 | SO-1401682 | 697.2
100010 | SO-1409914 | 657.9
100010 | SO-1414465 | 457.5
100010 | SO-1419997 | 391.7
100010 | SO-1422791 | 358
100010 | SO-1425898 | 578.6
100010 | SO-1429956 | 353.95
100010 | SO-1434901 | 681.1
100010 | SO-1434930 | -217.3
100010 | SO-1438411 | 191.2
100010 | SO-1444977 | 433
100010 | SO-1448542 | 7.95
100010 | SO-1450885 | 269.25
100010 | SO-1453226 | 91.7
100010 | SO-1458350 | 74.25
100010 | SO-1468066 | 145.15
100010 | SO-1473706 | 455.95
100010 | SO-1475758 | 178.5
100010 | SO-1478067 | 1491.15
100010 | SO-1482723 | -1074
100010 | SO-1485884 | 51.7
100010 | SO-1502089 | 159.2
100010 | SO-1505340 | 38.3
100010 | SO-1523786 | 359.2
100010 | SO-1543188 | 68.25
100010 | SO-1556138 | 64.25
100010 | SO-1557587 | 54.6
100010 | SO-1560494 | 199.25
100010 | SO-1562789 | 274.5
100010 | SO-1563694 | 143.8
100010 | SO-1569310 | 744.45
100010 | SO-1572950 | 169.2
100010 | SO-1574427 | 256.45
100010 | SO-1578618 | 174.7
100010 | SO-1579265 | 245.5
100010 | SO-1582307 | 129
100010 | SO-1582322 | -129
100010 | SO-1583286 | 305.85
100010 | SO-1593245 | 702.56
100010 | SO-1595127 | 117
100010 | SO-1598037 | 535.8
100010 | SO-1600099 | 442.35
100010 | SO-1600986 | -586.1
100010 | SO-1601346 | 734.95
100010 | SO-1604801 | 759.36
100010 | SO-1607597 | 579.52
100010 | SO-1609852 | 199.52
100010 | SO-1609992 | -143.92
100010 | SO-1611183 | 1618.5
100010 | SO-1612076 | 1347.52
100010 | SO-1612121 | -55.6
100010 | SO-1616589 | 569.48
100010 | SO-1621690 | 860.52
100010 | SO-1625935 | 463.6
100010 | SO-1627980 | 829.9
100010 | SO-1629647 | 463.6
100010 | SO-1629653 | -463.6
100010 | SO-1629990 | 568.94
100010 | SO-1635893 | 362.68
100010 | SO-1643672 | 174.1
100010 | SO-1648631 | 433.04
100010 | SO-1654482 | 333.7
100010 | SO-1664619 | 1579.6
100010 | SO-1666379 | 352.3
100010 | SO-1676717 | 255.87
100010 | SO-1683614 | 250.9
100010 | SO-1700617 | 132.4
100010 | SO-1705037 | 144.8
100010 | SO-1710933 | 157.44
100010 | SO-1734040 | 669.49
100010 | SO-1736264 | 114.92
100010 | SO-1742210 | 98.45
100010 | SO-1743499 | 439.9
100010 | SO-1757795 | 3348.48
100010 | SO-1765039 | 52.36
100010 | SO-1782070 | 225.71
100010 | SO-1784252 | 212.12
100010 | SO-1795828 | 324.3
100010 | SO-1798705 | 250.8
100010 | SO-1800961 | 376.65
100010 | SO-1803678 | 353.7
100010 | SO-1804570 | 366.24
100010 | SO-1808381 | 688.43
100010 | SO-1810416 | 274.88
100010 | SO-1820728 | 221.9
100010 | SO-1826895 | 860.95
100010 | SO-1830595 | 222.08
100010 | SO-1833449 | 554.32
100010 | SO-1838481 | 657
100010 | SO-1839816 | 703.3
100010 | SO-1841968 | 765.82
100010 | SO-1843460 | 698.8
100010 | SO-1845454 | 3939.76
100010 | SO-1848313 | 927.26
100010 | SO-1851841 | 700.68
100010 | SO-1856340 | 1037.06
100010 | SO-1862056 | 5598.4
100010 | SO-1889729 | 344.32
100018 | Total | 20.5
100018 | SO-1300575 | 0
100018 | SO-1310280 | 18.44
100018 | SO-1314582 | 20.5
100018 | SO-1314594 | -18.44