Dear we need only pending Amounts against deposited Amount,but that provide all.

if Data is
TransectionID,CustomerID,Date,DebitAmount,CreditAm ount
1, 1,1/1/2009, 24,000,0
2, 1,4/1/2009, 22,000,0
3, 1,4/1/2009, 16,000,0
4, 1,4/1/2009, 36,000,0
4, 1,4/1/2009, 0, 50000

then Correct Result is
TransectionID,CustomerID,Date,DebitAmount,CreditAm ount
3, 1,4/1/2009, 12,000,0
4, 1,4/1/2009, 36,000,0

but that result is not comming