Percent of the total for a distinctcount in a cross-tab 1

[borisbe]

I'm using version 9.

My cross-tab so far. The enrls are totaled by using distinctcount instead of sum.

Area Enrls
ART 5
DANCE 15

Total 20

Is it possible on a cross-tab to get the percentage of the total per area so:

Area Enrls Enrls Percentage
ART 5 25%
DANCE 15 75%

Total 20 100%

Thanks for your help.

 

[kenhamady]

Add a second summary field to the crosstab that is the same as the first, then check the option for 'show as a percent of total'

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[borisbe]

Thanks Ken. Sorry it took awhile to reply back. I just tried it and it worked but now I need to change it to show 2 decimals so 0.46% instead of just 0% since most of them (not all) will be below 1%. I right clicked on the percent field in the crosstab then clicked format field and changed the number to decimals from 1 to 1.00 and rounding from 1 to 0.01 then clicked OK but it didn't take the changes and still just shows 0%.

Help again is very appreciated.

 

[kenhamady]

Unfortunately, version 9 will not show decimals on a percentage of a distinct count:

http://kenhamady.com/cru/archives/28

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[borisbe]

Thanks Ken.