Cross-tab

[crystalbeginner15]

I have created a report using cross-tab. I need another column to be added for percent which is row's total divided by total's column total.

Please give me any suggestions how to do this.

Thank you.

 

[Madawc]

Which version of Crystal? It makes a difference.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[crystalbeginner15]

I am using CR11.

 

[Madawc]

This is how I'd do it in Crystal 10. First do a formula, value%total{/b]. Then right-click on the Crosstab and choose Crosstab Expert. Add the formula field as a Summarised Field.

If this results in totals you don't want, then right-click, Format Field and suppress those totals.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[crystalbeginner15]

What is here? And how do I get the value and total from the cross-tab

 

[lbass]

Create a formula like this:

{table.value} % sum({table.value}}

Add this as a summary field with sum as your summary. Then in preview mode, select the summary and click on the % icon in the toolbar.

-LB

 

[Madawc]

I wrote

value%total{/b] when I meant value%total, text in bold. A curley bracket in place of a square one, which meant the software here didn't understand it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[crystalbeginner15]

I added the formula in the summary field with sum as summary but when I preview the report I don't see a seperate column for percent instead I see the percent for each column put in each cell.

 

[lbass]

If you want a separate column with the percent just for the row totals, then you will have to do a manual crosstab. Or you could format the summaries to a horizontal display, suppress the summaries within the internal cells, and resize them to eliminate the white space. Didn't test this, but it might work.

-LB