Designing a two dimensional table

with your help i have designed most of the dashboard i needed. I owe you so much and I don't know how to thank you for your support.

the only thing that is left is a two dimensional table which has 12 columns (number of questions in the data model) and 32 rows (number of cities).

there are 2 things that i don't know how to create:

1- the table structure itself ( since the question has 5 possible answers {highly agree,agree,highly disagree, no opinion} when i chose the questions for dimension it shows the possible answers : {highly agree,agree,highly disagree, no opinion} , but l want to have the percentage of people who are {highly agree,agree,highly disagree, no opinion} in all cities .

2- the way i should script to count the all the people who are {highly agree,agree,highly disagree, no opinion} in one city so i can calculate the percentage.

as you can see in the picture below, i have to have 5 row for each city to see the percentage of each possible answer. i guess it's a little tricky..isn't it?