Please Help - Pivot Tables

Occasional Visitor


I'm calling a number of students to find out how they are going and wanted to create a pivot table to summarise the total for each category under concern 1, concern 2 and concern 3; i.e. how many people see program selection as their main concern. I have created drop down lists for all the foreseeable concerns and will select one from each column; however, when I create a pivot table, it doesn't total the different fields. I have attached screenshots. 


Any help would be great appreciated :)



1 Reply

Hello Katie


You have to split your table in a table with general information and a table with the categories. The latter table can be used for the pivot table.