Print Page - Distinct count summary output in a list

Title: Distinct count summary output in a list
Post by: lifzgud on 04 Sep 2009 03:36:17 AM

Hi i am preparing a list report
I have grouped a few columns
eg A ..then B..then C..eg if two divsion nos are identical they will be grouped but if two region nos are identical but divsion nos are not they will not be grouped..
A B C
1 2 A
3 B
2 2 A
I need a distinct count on B.but when i'm doing a count on B its format is getting inconsistent because of the grouping,.plz help

Title: Re: Distinct count summary output in a list
Post by: cschnu on 08 Sep 2009 01:11:12 PM

Quote from: lifzgud on 04 Sep 2009 03:36:17 AM
I need a distinct count on B.but when i'm doing a count on B its format is getting inconsistent because of the grouping,.plz help

What do you mean by format?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lifzgud on 04 Sep 2009 03:36:17 AM