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.