Aggregation

[Moff2123]

I am running a report in Cognos Report Studio and am having trouble getting the data to display with the appropriate aggregation.

The report is displaying the "total amount" multiple times for each Attribute. When I run the statement I get the correct results: Below is a breif example

My Results
LT Amount
AA 125
BB 125
Tot 125

Correct Results
LT Amount
AA 75
BB 50
Tot 125

I apprecite any help!! Thanks

 

[blom0344]

The correct result shows the standard Cognos behavior when totalling individual values. Somehow your aggregate is set to totalize for all LT

Check the SQL generated and the expression on amount..

Ties Blom