Percent in crosstab
Hi professionals out there,
I need some advice for the crosstab.
I'd like to have percentages in the rows instead of the sum.
A1 A2 B1 B2 C1 C2 total
customer1 1 7 40 44 3 5 100
customer2 44 55 1 55 45 200
This is what I have.
And this is what I want:
A1 A2 B1 B2 C1 C2 total
customer1 1% 7& 40% 44% 3% 5% 100%
customer2 22% 27,5% 0,5% 27,5% 22,5% 100%
Is there a way to get this ?
Thanks in advance,
Robert
I need some advice for the crosstab.
I'd like to have percentages in the rows instead of the sum.
A1 A2 B1 B2 C1 C2 total
customer1 1 7 40 44 3 5 100
customer2 44 55 1 55 45 200
This is what I have.
And this is what I want:
A1 A2 B1 B2 C1 C2 total
customer1 1% 7& 40% 44% 3% 5% 100%
customer2 22% 27,5% 0,5% 27,5% 22,5% 100%
Is there a way to get this ?
Thanks in advance,
Robert