Pivot table. Calcualting % from subtotals.
 

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...

Maybe I need to change source data somehow?

"Ray D" wrote:

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...