If I understand correctly, then you were very close with the calculated field you created. A few things just needed to be added:
IF Lookup(ATTR([ID]), -1) = attr([ID]) AND Lookup(ATTR([Date]), -1) = attr([Date]) THEN previous_value(1) + sum([Amount])
Hope this helps!
This works! Thanks Tracy