Summarize Survey Results

[jake_1993]

Hi Alteryx community,

I've used the following workflow to summarize the data below (survey results) into the following...

--->

--->

Using this workflow:

Is there a way to put all of the survey questions on Column 1, and then use Column 2-5 to display the Sums for each answer (Agree/Disagree, etc.,) ? This would be used to create a dynamic table in Power BI with questions displayed vertically instead of horizontally. 

Thanks for your help,

[DataNath · Accepted solution]

Hey @jake_1993, from a glance/without mocking something up, it looks like you should be able to use your existing workflow. When you do your final Cross Tab, just 'Group By' the field that contains your questions, and use the field containing the responses (agree/disagree etc) as your header, with [Dummy] as your Value, Sum() as aggregation.

[jake_1993]

Looks like this did the trick here! Appreciate the input.