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
Group by your preference utilizing a Header and / or Footer.
Use an Aggregate Total in the Header and / or Footer.
HTH, Bob
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.