Adding totals in a field using Relational database in Filemaker Pro

[newtoprogram]

I helping a non-profit organisation create a small database to keep track of donations made by the sponsors, I created two files named donations.fp5 and donators.fp5, where i link both using the relations membership id to donators ID, but i am getting into difficult when i want to create a report to generate all the donations made by each and all members in the year.
I am still pretty newbie in filemaker pro 6 but really want to help and complete this small project as the organisation cannot afford an out of the box software to do all these, it is also a learning opportunity for me as i am helping them out, so please anyone who can help, could help with me send tips on how i can get this this report to give a reasonable result.
Rigght now, when i run the report, instead of the totals for each member, it gives the totals for all the members added together.
thank you

 

[JeanW]

To make it easy for you, look in the help file for
'Report with grouped data and totals troubleshooting'.

There are several examples of common subsummary reports and the layouts that created them.

...and I have ome doubts about your relationship 'both using the relations membership id to donators ID'...