I have a bit of a complicated requirement - at least it is complicated to me which is why I am hoping to get an assist.
I have a report that has columns (there is more but this is the only necessary info)
Account Officers Loan Renewal Loan Amount
Joe Smith New 100.00
Larry Jones Renewal 200.00
Joe Smith Renewal 500.00
Angie Lowe Renewal 100.00
There are various account officers and I need a Dollar Amount breakout of Total Dollar amount of Loan Renewals that are new and a total of Loan renewals that are renewals for each officer.
What I am looking for is
Joe Smith Total New =100.00 Total Renewal = 500.00 Loan Total = 600.00
Larry Jones Total New = 0 Total Renewal = 200.00 Loan Total = 200.00
Angie Lowe Total New= 0 Total Renewal = 100.00 Loan Total = 100.00