Sounds like you may have an issue with the scope. So you probably need something like SUM(TotalTurnover.Value, [Group Name]). Check out BOL, http://technet.microsoft.com/en-us/library/dd283120(v=sql.105).aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question