COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: roland5599 on 10 Jul 2017 08:27:09 AM

Title: distinct counts on summary lines
Post by: roland5599 on 10 Jul 2017 08:27:09 AM
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...