I have Sharepoint Surveys which return information in the form presented as the first table in the reduced test case file.

I have created a second table to illustrate the possible answers.

I would like to create a table counting the "Sim" and "Não" (Yes and No) and Chart it using Pivot Tables, but I haven't found a way to count the text information to give me the desired table format.

I would appreciate help on this matter, thanks!

(I'm new to Pivot Tables)

reduced test case.xls:
reduced test case.xlsx