Percent in crosstab

[kvena]

I have a cross tab report that looks like this:
Corporation Foundation Group

Urban $5000.00 $4500.00 $300.00
5 1 2

Rural $4000.00 0 $50.00
5 0 2

I want to find out the percent for each urban and rural count by constituency type. For Example.

Corporation Foundation Group
Urban 50% 100% 50%
Rural 50% 0% 50%


Can this be done in a cross tab?

 

[synapsevampire]

Depends on your software version, please take the time to post the basics.

It's probably under the Summarized Fields->Change Summary and select the Show as a percentage of for your field.

-k

 

[lbass]

It is almost always critical that you report your CR version, and it is especially true when working with crosstabs.

-LB

 

[kvena]

I am on Crystal 8.5.

 

[lbass]

If you can use SQL expressions, you can do the following. Create two SQL expressions:

[%cell:]
(select count(A.`customerID`) from Table A where
A.`Constituency` = Table.`Constituency` and
A.`Environment` = Table.`Environment`)

[%coltot:]
(select count(A.`customerID`) from Table A where
A.`Constituency` = Table.`Constituency`)

You need to substitute your exact field names and replace "Table" with your table name. Leave "A" as is, as it represents an alias table name.

Then create a formula {@percent}:

if {%cell} > 0 then
{%cell} % {%coltot}

Add the formula as a summary field in your crosstab. Exit the crosstab and then right click on the summary and change the summary to a maximum (if you do this while in the crosstab, you might get a Dr. Watson). Then while the summary is selected, click on the % sign in the toolbar. This will give you the correct percentages within the inner cells of the crosstabs. If you wanted to also show the percentages in the total row, you would have to overlay a second crosstab with a different calculation.

-LB