Pivot Table Layout
 

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

Pivot Table Layout
 

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

Pivot Table Layout
 

Thanks. It did the job.
Andy