Aggregation Issue!!

[k2]

Hi there,

I am currently facing aggregation issue in my report/framework. I have tried a report which is suppose to bring back 4 values and display the total of those 4 values, but it is displaying only 1 value (which is minimum) out of the four. when i tried running the Native SQL against the DB, it is bringing back the sum of 4 values.

I am reporting the numeric value against Country field only. The numeric field is mentioned as Fact with Aggregation SUM in Framework.

Please help me out if am doing anything wrong. Am using Cognos 8.4 against SQL Server 2005.
Your responses will be much appreciated. Cheers

¬ K 2