Filter survey data with a pivot chart

[andrw]

Hello,
I had a survey where I ask people their age group and a question (scale from 1-10), now I'd like to know how age group is affecting the answer to the question. problem is I don't have the same number of responses for each age group which results in a high sum of the question answers for this age group. how should I solve this?

 

[pbornemeier]

Add a calculated filed that shows the sum of answers of that question in each group by the count of respondents in each group.