Pivot table to show percentage of occurences compared with the total number

Copper Contributor

Hi, sorry if this has been answered before.

I have a table where pupil results are recorded term on term.  They are recorded in letters such as ARE, ARE +2, ARE -2 etc etc.  

I have a pivot table but would like to see what percentage of the children achieved ARE (or any of the other grades) each term.  

I seem to only get 100% each time because it compares the number of occurrences with the number of the selected category which will always be the same.

 

I have made a mock up with dummy data in so that you can see what I mean.

 

Thanks 

2 Replies

Hello Chris

 

Use Get and transform to unpivot your data.

Then pivot it.

 

Thank you,

 

Took a while for me to get my head around Get and Transform but it worked perfectly.

 

Thanks,

Chris


@Detlef Lewin wrote:

Hello Chris

 

Use Get and transform to unpivot your data.

Then pivot it.