Grouping issue - Mart

I don't know if this can be done or not but trying to do it anyways. In the
first table below is my result set. This is an example of an person who made
a donation (Total of 1250.00) and payments ( 3 Payments at 138.00 each) on
those donations. The sum of the payments may not = the donation amount. I
have 4 groupings. Primary, Sub, Person and Donation, and finaly Payment. The
problem is that when I try and display the donation amount at the third
grouping and above, it becomes the sum of the donation * the number of
payments. I can understand that because it shows up on every row for each
payment but I just don't know how to get around it.  The second table is what
I am trying to achieve.



Thanks for the help.
Marty



Primary	Sub	Person	Donation_Amt	Payment
1	1	1000	1250.00	               138.00
1	1	1000	1250.00	               138.00
1	1	1000	1250.00	               138.00



Primary	Sub	Persons	Donations	Total Payments
1			1250.00
1		1250.00
1000	1250.00	414.00
138.00
138.00
138.00


--
Marty