Cross Tab Summary Operation

[TerriO]

CR 9

I have to create a cross tab (manual Cross tab not an option because the columns are dynamic)

column Survey questions 1 2 3

row
Sales person % of yes for each question

Returned to me is the Count of yes, count of yes and no, count of no... problem , I can create a formula (yes/total yes/no) to give me the percentage but the cross tab wants to do a summary function on the value which is giving erroneous values. Is there anyway around this?

Terri

 

[IdoMillet]

Hi Terri,

Create a formula that returns 100 for "Yes" and 0 for "No"

Use the CrossTab to average that formula.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

Just to clarify, the technique above requires access to the raw records. If all you have in the database is summary information per sales rep x question, you won't be able to use it.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TerriO]

Salesperson Metric Yes Count No Count YES/NO
Terri Courtesy 3 1 4



The above is the data returned. I am not sure how to use your solution, if its applicable. Could you explain a little more, if I need it for future reference?

Terri

 

[IdoMillet]

If you have access to the detail data, then the solution above will work. If the data source contains only the totals, it will not.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TerriO]

So there is no other solution?

Terri

 

[IdoMillet]

Can you specify if you have access to the detail records? It is till not clear to me.

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TerriO]

Can you be more specific on your solution, I can try to get the data in that format.

Terri

 

[IdoMillet]

Good.

OK, imagine you have 10 detail records for one sales person and one question. 4 of them are "Yes" (100) and 6 of them are "No" (0).

Averaging the 100 or 0 formula would return 40,
which is exactly the percent Yes. Just turn on the Percent sign and you are done... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TerriO]

I am still struggling got the data back returning only the salesperson, question , and a yes column and a no column.

Terri

 

[TerriO]

Nevermind JUST GOT IT!

Terri

 

[TerriO]

THANK YOU SO MUCH FOR YOUR HELP.... !!!!!

Terri

 

[IdoMillet]

Glad it all came together for you... )

Actually, you didn't need a 'yes' column and a 'no' column. You just need the answer column as the basis for the 100_or_0 formula.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com