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
Bookmarks