Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Layout
Thanks. It did the job.
Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |