Maps and Aliases

[ellinj]

I am creating a map report based on the following data using a US 48 Map and Cognos 8.4
STATE CVAL
NC 110
SC 4
North Carolina 45
N. Carolina 44

STATE Goes in the location field and CVAL goes in the color field.

The report gives me an error due to mismatched data. Therefore I added N. Carolina as an alias for North Carolina.

When I run the report I am getting a value of 44 for NC.  I assume that this is because it is the last value applied to the report.  What I really want to happen is for it to give me a value of 209.

Any ideas?