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