Forum Discussion

Copper Contributor

Feb 10, 2019

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

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 b...

mock up.xlsx17 KB

excel

Detlef_Lewin

Silver Contributor

Feb 10, 2019

Hello Chris

Use Get and transform to unpivot your data.

Then pivot it.

techcommunity_333875_M25355.xlsx30 KB

chris-conners

Copper Contributor

Feb 10, 2019

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.