Erin Leale
asked on
Crystal Report - Cross Tab - with percentage
Good afternoon,
I have a cross tab report that summarizes Credits and Invoices - I need a percentage at the bottom to show the percent of credits vs invoice for the categories.
I'm not all that savvy with Cross Tab reports - so I need some help on getting the Percentage to show. Can you help?
Thanks!
Attached example of Cross tab and report with Data
Cross-Tab-Example.pdf
AR_CreditRebill_expechange.rpt
I have a cross tab report that summarizes Credits and Invoices - I need a percentage at the bottom to show the percent of credits vs invoice for the categories.
I'm not all that savvy with Cross Tab reports - so I need some help on getting the Percentage to show. Can you help?
Thanks!
Attached example of Cross tab and report with Data
Cross-Tab-Example.pdf
AR_CreditRebill_expechange.rpt
ASKER
Thanks. Do you think it is possible to create a line underneath the cross tab with that information? Every formula I try returns 0. Not sure what I'm doing wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This worked. I thought I had responded but I must not have saved the response. Thanks James0628!
You're welcome. Glad I could help.
James
James
You should be able to put the value field in twice and show one as a % but then you will see the credits also.
mlmcc