Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table, functions for subtotals | Excel Worksheet Functions | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |