If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding Certain rows of the column

Started by naveen_hadagali, 15 Oct 2007 05:38:46 AM

Previous topic - Next topic

naveen_hadagali

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

rockytopmark

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

naveen_hadagali

Thanks rockytopmark, It worked...