If the sum hasn't worked and your SalesYear are really numericals like 2011, I assume you need to clear selections in other fields that are incompatible with your selection in SalesYear (e.g. do you have also selections in SalesDate or SalesMonth? Then you need to clear these fields: