Drag "AFFILIATION" from the Color shelf to Level of Detail
Drag a copy of "SUM(SPOT COUNT)" from the Rows shelf to the Color shelf (ctrl+click and drag the pill)
Edit the colour legend as required (e.g. use 2 steps, and change the red to blue)
That works, thank you!