Janine McLean
New Member
I am trying to set up a pivot table to show the following
Subject Level No of pupils in Subject % of pupils >50% result % of pupils between 35-49%
I really need to know the number of pupils by subject and level who have achieved 50% or more, 35% or more, less than 50% and less than 35% in their mid term exams.
I have tried to do this using a pivot table but I am getting a bit lost. Any help will be much appreciated. I have uploaded a sample file.
Subject Level No of pupils in Subject % of pupils >50% result % of pupils between 35-49%
I really need to know the number of pupils by subject and level who have achieved 50% or more, 35% or more, less than 50% and less than 35% in their mid term exams.
I have tried to do this using a pivot table but I am getting a bit lost. Any help will be much appreciated. I have uploaded a sample file.