I would like to do a pivot on the below table which will show me data as percent of the 2 columns "> 3 Score" and ">4 Score"
My table is :
Country Month Q2 Score Q3 Score Q4 Score Q5 Score Q6 Score > 3 Score > 4 Score
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 4 3 4 4 4 1.00 0.80
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 5 5 5 5 5 1.00 1.00
GBR Aug-17 5 5 5 5 5 1.00 1.00
My desired table should look line
> 3 Score > 4 Score
Aug-17 100% 97.5%
Bookmarks