Perfect! That's exactly the answer I was looking for. I tried all sorts of SUM OVER PARTITION BY combinations with no luck, but I see the PARTITION wasn't required. I guess I was over-thinking it.

Thank you so much, JLS. If ever you want a really good bottle of wine, just let me know 😀

Gina