COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: generh6957 on 10 May 2007 06:34:19 PM

Title: simple quesiton in report studio
Post by: generh6957 on 10 May 2007 06:34:19 PM
This has got to be a simple request, but being a novice user please help.
I have a simple list of market and order number.  I want to count up the order number (all text fields) so that I just have market and total number of orders.

This is what I have...
Las Vegas  ABCEDSJ
Las Vegas  ABCEDSJ
Las Vegas  ABCEDSJ
Las Vegas  ABCEDSJ

This is what I want...
Las Vegas  4
Title: Re: simple quesiton in report studio
Post by: COGNOiSe administrator on 10 May 2007 07:09:23 PM
change your second column to count(second column). Or change aggregation to count.