I am fairly new to Crystal Reports but am trying to get up to speed so many of the reports I have to provide can be run by an enduser as opposed to me having to run it for them through a download into Excel.
I am trying to calculate workforce diversity percentages to track the success of our Affirmative Action Plan. What I want to do with a cross tab is calcluate percentages against the grand total, either by department or organization wide. Using the table below, I would like to be able to calculate the percentages for each category (Asian Female) based of of the Grand Total (48). The crosstab function in Crystal looks like it calculates based off of the group total (Asian Female is calculated based off the Femal total). Is there someway I can get it to use the Grand Total?
| Count of ID |
Gender |
|
|
| Ethnic Grp |
F |
M |
Grand Total |
| Asian |
1 |
1 |
2 |
| Black/African American |
3 |
|
3 |
| Hispanic/Latino |
10 |
1 |
11 |
| White |
30 |
2 |
32 |
| Grand Total |
44 |
4 |
48 |
Any Help would be appreciated, just remember I am farily new, so I will need the remedial version.
IP Logged
