Pivot table. Calcualting % from subtotals.

G

Guest

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

Average of Subtotals in Pivot Table 0
Pivot Table: Variance formula 2
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table 1
sum by rows in Pivot 1
Pivot Table Layout 2
Pivot Table Percent Question 4
Pivot Table Conditonal Format of the Grand Total 3

Top