Analyse survey with Pivot

[jules_5]

Hi there,

I need to analyse a survey with 10 different questions. The users answered by clicking: Agree, Disagree, neither nor etc... Furthermore their working location (5 different) is part of the survey. The raw data is as the following: Coloumns -> different Questions with scores (agree, disagree etc) above, Rows -> Location of every user.

I wanted to create a pivot with the different questions in the rows and the scores (filtered by the location) as percentages above. Hopefully you can help me.

Thanks!

[glennchung]

Can you upload your workbook?