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?