Crosstab display a percentage of col1/col2 1

[careymw]

I'm working with a cross tab...and I am having difficulty getting a precentage column to function correctly.

I have 3 columns
Survey
Top Box
% Top

I have 5 rows that are the business units.

I would like the % top column to be the % top box to survey.
So for example
Business Survey Top Box %
ISG 23 19 %82.61

I can't get the percentage to work properly.

 

[lbass]

Please identify your version of CR and also go into the crosstab expert and identify the rows, columns, and summaries by actual field names.

-LB

 

[careymw]

Sorry. I'm using Crystal 2008.

Rows:
@Business Unit

Columns
@Day of week

Summarized Fields:
Survey (sum)
Score (sum)
% score to survey (max)

I can't get the percentage (3rd summarized) to work properly in the crosstab format.

 

[lbass]

I don't have CR2008 loaded in my current location, and it has new crosstab functionality. I'll try to look at this over the weekend, but maybe someone else can respond.

-LB

 

[lbass]

Sorry, I forgot about this. You can try the following method, which worked for me when I just tried it in CR2008. I have had some trouble with using formating formula areas to create summaries, but it appears to work in this case.

Select the Survey summary (totals and inner cells)->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar tot := currentfieldvalue;
false

Then select the score summaries in all cells->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar curr := currentfieldvalue;
false

Then add a third summary based on this formula to act as a holder:

whilereadingrecords;
0

Right click on this summary->format field->DISPLAY STRING->x+2 and enter:

whileprintingrecords;
numbervar tot;
numbervar curr;
if tot <> 0 then
totext(curr%tot,2)+"%" //2 for two decimals

There might be a better way to do this in CR2008, but I haven't figured it out. I think Ken Hamady has a guide to crosstabs in CR2008, which might be helpful:

http://www.kenhamady.com.

-LB

 

[careymw]

Thank you I will give this a try.

 

[careymw]

I was finally able to get back to looking at the suggestions for this cross tab report. That worked wonderfully. I knew it had to be able to be accomplished. I appreciate your help, Thank you.