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

How to get count without showing customer_id

Started by newyork66, 15 Nov 2007 09:26:10 AM

Previous topic - Next topic

newyork66

I have a customer_id field. I want it to be counted, ( group by YEAR and MONTH), but I dont want it to be showed. Do you know how I only get total count number for YEAR and MONTH without showing each Customer_ID?

rockytopmark

Have list with 3 columns, [Year], [Month] and [Customer Count]

Customer Count expression is: count([Customer_ID])

Group the list by Year and Month