Percentages in Cross Tab

[harrietohs]

I use Ver. 8.5. I have a simple cross tab report with one Column, Animal Type, and 1 Row, Kennel Outcome Type. The summarized field is: Count of Kennel Outcome Type. I would like to add another summarized field that displays the count as a percentage of the total for each animal type. The result would be something like:

CAT DOG Total
RTO 10 28.5% 25 50% 35
ADOPTION 25 71.5% 25 50% 50
TOTAL 35 50 85

Can this be done via a cross tab? I have done it via a standard report, but would prefer a cross tab.

 

[chelseatech]

You can do it in CR8.5 using a Manual crosstab (use formula to calculate on a conditional fields and summarise those).

CR9 supports percentages and running totals in a crosstab

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[harrietohs]

Unfortunately, the application (Chameleon) I use in conjuction with Crystal does not yet support ver. 9. I will continue with the manual crosstab.

Thanks.