Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ranne_78 on 09 Jan 2008 12:31:23 PM

Title: Count in reportstudio
Post by: ranne_78 on 09 Jan 2008 12:31:23 PM
Hi All

I have  dataitems productline,product type, product id.

I need to get unique count of product id for product type and product line in single dataitem.
In my report we don't want to show product line and producttype.
We need to show the count for unique combination of product-id for productline and product type.

I have only three items in my list report  those are State
                      location
                       Combination  of product-id 
Title: Re: Count in reportstudio
Post by: MFGF on 09 Jan 2008 03:05:15 PM
Deja vu.  I'd swear I just answered a post almost exactly like this one.  I must be getting senile in my old age.

Maybe this helps:

http://www.cognoise.com/community/index.php?topic=3479.0

Regards,

MF.
Title: Re: Count in reportstudio
Post by: ranne_78 on 09 Jan 2008 03:48:08 PM
Quote from: ranne_78 on 09 Jan 2008 12:31:23 PM
Hi All

I have dataitems productline,product type, product id.

I need to get unique count of product id for product type and product line in single dataitem.
In my report we don't want to show product line and producttype.
We need to show the count for unique combination of productid for productline and product type.

I have only three items in my list report  those are State
                      location
                       Combination  of product-id 

Thanks but it doesn't work for me
Any more Ideas please\
Text only | Text with Images