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

distinct counts on summary lines

Started by roland5599, 10 Jul 2017 08:27:09 AM

Previous topic - Next topic

roland5599

I have a package item donor counts that I need to summarize in a grouping with distinct count. If I use donor count on its own it works fine. Now I need to split up donor count with an expression so I can separate it out by year.  So I will be getting the same summary grouped totals but separate for 2016 and 2017. When I do this with data item expressions, the total at the very end is distinct but the ongoing grouped summaries are not distinct. I have tried setting this up every which way but nothing gets me the distinct count on the grouped summaries. Anyone have any ideas on how to handle this? Thanks...