R
Ray D
Hi, All!
I have such pivot table:
Answer2
Quest1 Answer1 male female
Do you have a hobby? Yes 5 10
No 3
4
Total 8 14
Do you smoke? Yes 7 3
No 2 7
Total 9 10
etc...
Grand Total ...
How can calcualte in the data area percent of the total sum in column? "%
from column" calculates it from the Grand Total.
Thanx in advance...
I have such pivot table:
Answer2
Quest1 Answer1 male female
Do you have a hobby? Yes 5 10
No 3
4
Total 8 14
Do you smoke? Yes 7 3
No 2 7
Total 9 10
etc...
Grand Total ...
How can calcualte in the data area percent of the total sum in column? "%
from column" calculates it from the Grand Total.
Thanx in advance...