Home

Please Help - Pivot Tables

KatieAllan1990
Occasional Visitor

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

 

 

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.