dukeslater
Technical User
Not too strong on crosstabs, so hopefully this won't be too difficult. I have a crosstab which calculates employee terminations by week:
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
I also have a static number of total employees at the beginning of the period, which I have brought into the crosstab as a maximum:
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
75 75 75 75 75
Now what I can't quite get is the percentage of each weekly total/the static figure of 275
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
75 75 75 75 75
.013 .026 .013 .04 .093
As always, thanks in advance for your help. I'm using CR XI R2.
John
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
I also have a static number of total employees at the beginning of the period, which I have brought into the crosstab as a maximum:
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
75 75 75 75 75
Now what I can't quite get is the percentage of each weekly total/the static figure of 275
11/1 11/8 11/15 11/22 Total
1 2 1 3 7
75 75 75 75 75
.013 .026 .013 .04 .093
As always, thanks in advance for your help. I'm using CR XI R2.
John