Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bonniehsueh on 24 Jul 2008 10:00:23 AM

Title: Merging values?
Post by: bonniehsueh on 24 Jul 2008 10:00:23 AM
With a dimensional data source, in a crosstab, I need to show the sales of two products together using a differnt name.

For example, using Great Outdoors Company, how would I show the sales for Camping Equipment and Golf Accesories as 'Outdoor Activities'?

Camping Equipment  $4000
Golf Accecories  $3000

The result should be:

Outdoor Activites   $7000

Thanks
Title: Re: Merging values?
Post by: bonniehsueh on 24 Jul 2008 10:31:23 AM
I got it. I was complicating it more than it needed.

[Camping Equipment] + [Golf Accessories]
Text only | Text with Images