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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies