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 count summary output in a list

Started by lifzgud, 04 Sep 2009 03:36:17 AM

Previous topic - Next topic

lifzgud

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

cschnu

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?