Pivot table. Calcualting % from subtotals.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top