I have asked HR to complete a staff survey and want to analyse the result and thought a Pivot Table would be the best option.
I am not sure if it has been a long week but I am struggling to get the pivot to do what I need! I basically want to be able to filter by school (in column B) and then also by type of staff (column c) but then analyze each question to work out what % of the staff agree, strongly agree, disagree etc etc. When i drop the questions in the row section and then into count values it shows the same values for every question instead of the diferent counts for each question individually.
I'm sure its something really simple I'm missing but any help would be appreciated.
I am not sure if it has been a long week but I am struggling to get the pivot to do what I need! I basically want to be able to filter by school (in column B) and then also by type of staff (column c) but then analyze each question to work out what % of the staff agree, strongly agree, disagree etc etc. When i drop the questions in the row section and then into count values it shows the same values for every question instead of the diferent counts for each question individually.
I'm sure its something really simple I'm missing but any help would be appreciated.
