Hi,
First here is the general setup of my pivot table.
country
type data ca ch croa
HWD y_cons 15 53 15
y_cap 16 50 14
cf .91 1.06 1.05
SWD y_cons 74 30 52
y_cap 72 29 100
cf 1.03 1.04 .52
total sum y_cons 89 83 67
total sum y_cap 88 79 114
total cf .98 1.05 .59
What I am trying to do is have my cf=y_cons/total sum y_cap (right now its simply =y_cons/y_cap). For example, I want cf under swd = 74/88, 30/79, and 52/67.
Reading various posts, I know how to make show y_cons as % of total (or row/column). Also, I can get my cf to be a % of these as well. Non of these solve my problem of having the y_cons under each country divided by the total of y_cap for that country.
Does this make sense? Any help would be greatly appreciated. Thanks!
First here is the general setup of my pivot table.
country
type data ca ch croa
HWD y_cons 15 53 15
y_cap 16 50 14
cf .91 1.06 1.05
SWD y_cons 74 30 52
y_cap 72 29 100
cf 1.03 1.04 .52
total sum y_cons 89 83 67
total sum y_cap 88 79 114
total cf .98 1.05 .59
What I am trying to do is have my cf=y_cons/total sum y_cap (right now its simply =y_cons/y_cap). For example, I want cf under swd = 74/88, 30/79, and 52/67.
Reading various posts, I know how to make show y_cons as % of total (or row/column). Also, I can get my cf to be a % of these as well. Non of these solve my problem of having the y_cons under each country divided by the total of y_cap for that country.
Does this make sense? Any help would be greatly appreciated. Thanks!