Pivot table. Calcualting % from subtotals.

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

[Ray D]

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