I think you'll need to create another table called "Rollup" or something and make sure to link all the records you want to sum up to a single record in that "Rollup" table

Then, you'd create a rollup field with "SUM(values)" to sum everything together

Finally, create an automation that'll automatically link any newly created record to that one record in the "Rollup" table and it should update as expected