Pivot Table - Just show Value in Summery no Calculation

[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.

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Convert numbers to letters
with custom font.
No extra formulas or helpers.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_21_10.xlsx

 

[Raf Dzji]

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