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
			
			
			
				change your second column to count(second column). Or change aggregation to count.