Home

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

chris-conners
New 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
Highlighted

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.

 


 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies