How to create cumulative sum based on a parent Item

I have 2 tables Actors and Movies. Actor have fields like Actor name, Dob. Movies have fields like Boxoffice Collections, Movie name, Cumulative collections. Actor and Movies have one to many relation...