For this, you’ll need your two tables to be linked together. If you haven’t already, add a Link to Another Record type field to one of your tables, and link each record in [Table 1]
to a record in [Table 2]
. Then, in [Table 2]
, add a Rollup type field. For the rollup’s settings, select the appropriate field from [Table 1]
and use SUM(values)
as the aggregation.