Hi,
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 :)
