Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cross Tab Report Summaries

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?

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question