Group By tile not working with large dataset

Hi, I have a dataset of about 4.7M rows. When I try to use the Group By tile in Magic ETL to find a sum of values across IDs, and then join back on the ID, the new sum column is blank. However, in testing, when I filtered the dataset down to about 50K rows to see what was wrong, the example ID I was checking now had the sum column populated. Is there a known issue with aggregations within big datasets? My ETL dataflow is identical to the testing instance, apart from the one filter tile to only have one ID.