Print Page - Adding Certain rows of the column

Title: Adding Certain rows of the column
Post by: naveen_hadagali on 15 Oct 2007 05:38:46 AM

Hi All,

I Have one requirement where i need to show total for each type ..Like for example

Type total
A XXXXX
B XXXXX
C XXXXX
D XXXXX
E XXXXX
F XXXXX

Now i can get this but issue is C, D ,E types are to be added means the above format should be like this

Type Total
A XXXXX
B XXXXX
C+D+E XXXXX
F XXXXX

Suggestions from you all will be highly appreciated.

Thanks in Advance

Regards
Naveen

Title: Re: Adding Certain rows of the column
Post by: rockytopmark on 15 Oct 2007 07:28:03 AM

Create a new Column Called "Report Type"

If [Type] in ('C','D','E')
Then 'C+D+E'
Else [Type]

Then do your aggregation using [Report Type] as the grouping

Title: Re: Adding Certain rows of the column
Post by: naveen_hadagali on 15 Oct 2007 09:01:13 AM

Thanks rockytopmark, It worked...

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen_hadagali on 15 Oct 2007 05:38:46 AM