After you add the two fields to the pivot table's data area, drag the
Data field button to the right, onto the cell that contains the word
'Total'.

There's a picture he
http://www.contextures.com/xlPivot02.html

step_andy wrote:
I am trying to summarise student data in a way that it displays exam score
and grade next to each other, eg
Maths History
1234 Jhon Citizen 75% 7 65% 6

So far I manage to get Pivot table to show grade underneath the score, eg

1234 John Citizen 75% 65%
7 6

Is there a way to this with pivot tables?
Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html