I am trying to pull percentages from a subsummary layout and can't seem to get it to work. Well, not exactly. I can get the percentage of the first subsummary breakdown, but it won't figure the percentages for the other 9 breakdowns in the subsummary layout. Does anyone have a formula for figuring percentages from a subsummary layout? Example: 11 people replied 0 to 10% , 5 people replied 11 to 20%, 6 people replied 21 to 30%, etc. Total responses to question one was 87. I can get breakdown to question one, but am unable to get the percent breakdown of 11 divided by the 87 that responded, or the 5 out of 87 that responded, etc. What am I not doing that I should be doing?
Any help would be appreciated.
Thank you. Paula paulairvin@comcast.net