http://forums.visokio.com/discussions/tagged/questionnaire_data/feed.rss Mon, 30 Oct 17 15:47:59 -0400 Tagged with questionnaire_data - Visokio Forums en-CA http://forums.visokio.com/discussion/3126/subset-formulas-calculating-of-total-per-category Thu, 12 May 2016 11:34:25 -0400 MPatel 3126@/discussions
I have survey data and i want to show data by the percentage of control and exposed respondents. The data is categorical.

Column A; Column B; Column C
Respondent 1 ; Control; Competitor A
Respondent 2 ; Control; Competitor B
Respondent 3 ; Exposed; Competitor C
Respondent 4 ; Exposed; Competitor A
Respondent 5 ; Exposed; Competitor B
Respondent 6 ; Exposed; Competitor C

The chart needs to show two bars for Competitor A, one control and one exposed. Control would be 50%, Exposed would be 25%. For competitor B it would show Control 50%, Exposed 25%. For competitor C it would show Control 0%, Exposed 50%.

Any idea how to do this??]]>