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.

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies