Feb 10 2019 07:06 AM
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
Feb 10 2019 07:47 AM
Hello Chris
Use Get and transform to unpivot your data.
Then pivot it.
Feb 10 2019 11:01 AM
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.