Summary cross tab report help requested
I have the need to present loan payment data with payments horizontally by term, and grouped by type of loan and downpayment.
My data is structured in a table called "Proposal Scenarios", as one record for each combination of Type/Down Payment/Term/Monthly Payment/and Rate.
I took a stab at using summary fields to consolidate, and was partially successful. Problem I have is when there is more than 1 record for same Type of purchase, Down Payment, term, AND the rate is different.
I set a summary field for Pmt 24, Pmt 36, Pmt 48, Pmt 60. Of course when there are duplicate records for a Pmt field (i.e. see Pmt 60 below) and summary field is set to "Total" it will sum the Pmt total for those records and thats not desired. Not a problem if there are not duplicate records.
I need to show rates for each grouping as well.
Table Record Data:
|Type||Down Payment||Term||Pmt 24||Pmt 36||Pmt 48||Pmt 60||Rate|
SUMMARY REPORT DESIRED RESULT(sorted by Type and Down Payment)
I cant figure out a way to do the consolidation, and hope someone might have some ideas for me!
Thanks in advance!!!