Link to home
Start Free TrialLog in
Avatar of Erin Leale
Erin LealeFlag for United States of America

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
Avatar of Mike McCracken
Mike McCracken

I don't believe you can get that to work with a cross tab.

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
Avatar of Erin Leale

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
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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