dear friends
i have dataset and i need to calculate the percentages ....
Pt Aebodsys aedecod
1 Soc1 pt1
1 soc1 pt1
1 soc2 pt1
2 soc1 pt1
2 soc1 pt2
I have a dataset like this and I want to create percentage like this..
Denominator is aebodsys count-group
Nominator is aedecod count-subgroup
Aebodsys aedecod n percent
Soc1 2 2/2=100
Pt1 2 2/2=100
Pt2 1 ½=50
Soc2 1 1/1=100
Pt1 1 1/1=100
thank you