I need help with calculation percentage within a crosstab, the percentage function calculates the percentage of the overall total. Here is a sample of what I have and what I need. I have tried adding a data item using the percentage function, it did not produce the results I need.
Year 1 Year 2 totals Total counts for the year
Total of participants 125 110 235
No of Females 75 60 135
No of males 50 50 100
Total Gender 125 110 235
Cat 1 80 90 170
Cat 2 45 20 65
Tot Cst 125 110 235
Year 1 % Year 2 totals % Total counts for the year
Total of participants 125 100% 110 100% 235
No of Females 75 60% 60 54.55% 135
No of males 50 40% 50 45.45% 100
Total Gender 125 100% 110 100% 235
Cat 1 80 64% 90 81.81% 170
Cat 2 45 36% 20 18.18% 65
Tot Cst 125 100% 110 100% 235
Thank you all