Record 1           $20

Record 2            $30

Record 3            $20

AddressXYZ

Record 1            $40

Record 2            $10

Record 3            $20

Using the Aggregate criteria in script builder how do I return the aggregate of a specific address. For example the aggregate for Address xyz as $70. When I try to limit the records by the ID = ID  i am still getting $140

The report is from a form where Address is a lookup field pointing to the Address Table.