cancel
Showing results for 
Search instead for 
Did you mean: 

Cross Tab Report Summaries

Former Member
0 Kudos

I have a cross tab report with a row for loan type and another row for Investor Name. The columns are for loan disbursements by month. The summaries are for the loan count for loan type, loan count as a % of loan type, sum of loan amount for loan type and sum of loan amount as a % of loan type. The monthly numbers and % are correct, as well as the final column for the totals.

The total number of loans and total sum of the loan amounts in the total row at the end of each loan type are also correct, but I want the % of loan count and % of loan amount in this row to be based on the total count of all loans on the report, not just the % of the loans in that particular loan type.

Can someone tell me how to modify the % count summary and % sum summary just on the total row printing for the loan type?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Diann,

Try to use the display string by right clicking on total field>format Field>Common tab-->Display string

and write the formula like

currentfieldvalue/count(field)

Regards,

Raghavendra

Answers (0)