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

Count in reportstudio

Started by ranne_78, 09 Jan 2008 12:31:23 PM

Previous topic - Next topic

ranne_78

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 

MFGF

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.
Meep!

ranne_78

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\