Pivot tables

I’m learning how to do pivot tables in Excel using data from Strictly Come Dancing.

I’m colouring the cells using conditional formatting.