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

How to Count the Product ID with DMR package.

Started by jd, 06 Dec 2010 03:18:51 PM

Previous topic - Next topic

jd

Hi,

I am working with DMR package.

I have 2 pages in my report. 1st page shows only the summaries.  2nd page is details for the summaries.

In first page I have Region and counts.

In second page region, counts with Product ID.

I have to use singleton in first page with showing the cound of Product ID for particurar region.

how to use the count function with DMR package for the Product ID

cognostechie

Click on the column heading of Product ID. From the toolbar, select the icon that is for totalling, select 'Count' from there. At the bottom of Product ID column, you will see it creates another row to show the Count. Click on that and from the properties on the left, click on 'Rollup Aggregate Function', select 'Count distinct' .

I just did this using a DMR package and it works.