Pivot Table - Just show Value in Summery no Calculation

  • Thread starter Thread starter Steve Audus, Chaucer BEC, Sheffield UK
  • Start date Start date
S

Steve Audus, Chaucer BEC, Sheffield UK

I am trying to use a Excel 2007 Piviot Table to translate this information

Name | Subject | Grade
Studentname 1 | Maths | D
Studentname 1 | Science | E
Studentname 1 | English | A
Studentname 2| Maths | A
Studentname 2 | Science | B
Studentname 2 | English | C

To a Privot Table like this

Name | Maths | Science | English
Studentname 1 | D | E | A
Studentname 2 | A | D | C

But it's showing this

Name | Maths | Science | English
Studentname 1 | 1 | 1 | 1
Studentname 2 | 1 | 1 | 1

Because in the Summery it's counting the grades.

How do I get excel just to show me the grade, and not count the grades?

thank you for any help.
 
hi all,

very useful answer, but can it also handle mixed data, like e.g. not only grades, but also more elaborated stuff like 'sick', 'did not show up' etc?

many thanks!

Raf
 
Back
Top