COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: newyork66 on 15 Nov 2007 09:26:10 AM

Title: How to get count without showing customer_id
Post by: newyork66 on 15 Nov 2007 09:26:10 AM
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?
Title: Re: How to get count without showing customer_id
Post by: rockytopmark on 15 Nov 2007 09:58:22 AM
Have list with 3 columns, [Year], [Month] and [Customer Count]

Customer Count expression is: count([Customer_ID])

Group the list by Year and Month