Pivot Table Layout

[Guest]

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]

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 here:
http://www.contextures.com/xlPivot02.html

 

[Debra Dalgleish]

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 here:
http://www.contextures.com/xlPivot02.html

 

[Guest]

Thanks. It did the job.
Andy

 

[Guest]

Thanks. It did the job.
Andy