Inside Custom tables calculations

[Rajeshms]

SPSS 21; win 7

Dear List,

I have attached the report by which I need to calculate some rates and statistics. 

I want the total columns counts to be divided by some other number. 

say for example:

In the attached , I have total still births by place of residence of mother,i.e 166 for urban and 293 for rural and 459 for total district of bagalkot. Now I need to calculate still birth rate, i.e 

(total still births) / (x+y). 

I can get x and y  for calculations. But how to get the tabulated value for other computations.

Is there any way to do this? I will be really happy if someone teaches me to get the above. 

(I tried with pivot table calculations,but I couldnt succeed as I dont knw python,)

Thanks to all.

​

 Still birth Rates.xlsx

​
--

Regards,

Rajesh M S

[GauravSrivastava]

you can add a new row/column in table using PCOMPUTE expression.

try somthing ;

  /PCOMPUTE &new = EXPR([X] / ([X] + [Y])*100)

Regards,

Gaurav

On Fri, Jan 18, 2013 at 12:35 PM, Rajeshms <[hidden email]> wrote:

SPSS 21; win 7

Dear List,

I have attached the report by which I need to calculate some rates and statistics. 

I want the total columns counts to be divided by some other number. 

say for example:

In the attached , I have total still births by place of residence of mother,i.e 166 for urban and 293 for rural and 459 for total district of bagalkot. Now I need to calculate still birth rate, i.e 

(total still births) / (x+y). 

I can get x and y  for calculations. But how to get the tabulated value for other computations.

Is there any way to do this? I will be really happy if someone teaches me to get the above. 

(I tried with pivot table calculations,but I couldnt succeed as I dont knw python,)

Thanks to all.

​

 Still birth Rates.xlsx

​
--

Regards,

Rajesh M S