Grouping into a single line

[Esosa]

How can I group the amounts into a single line? When I group it by group_no,

it looks like:

Group      Amount        Amount1         Amount 2
1                    20                  30                   15
1                    10                  15                   20
2                     5                   10                   15
2                    15                   5                    25


I want it to look like below:

Group      Amount        Amount1         Amount 2
1                    30                  45                   35
2                    20                  15                   40

[Cognos_Jan2017]

Group by your preference utilizing a Header and / or Footer.

Use an Aggregate Total in the Header and / or Footer.

HTH, Bob

[adam_mc]

All you have to do is set the detail aggregate property for all of your Amount/Measure Data Items to Total.

Then, by default, Cognos will automatically aggregate to the lowest level of granularity in the list.

Hope this helps,
Adam.