simple quesiton in report studio

[generh6957]

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

[COGNOiSe administrator]

change your second column to count(second column). Or change aggregation to count.