Summarize Survey Results

Question

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 Answer

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.