Group result and display count in a view I want to create a view and group the result like display only 1 record and along with it display the count of the similar records along with it. Can i do it in views with out writing any code. i.e. result should look like

Football (3)

Tennis (6)

Cricket (4)
My example is based on 1 Content Type and 1 field (City).


FIELDS. Add 2 same fields in fields area you wanna group and show counter.
FORMAT. Group by required field

PAGER. Set 0 in Pager area.
ADVANCED.
Enable aggregation in advanced settings

COUNT. Enabled 'count' for second field (which is not used to group)

Sorting. Set sorting as your group field.


FINAL

This is how looks my view


RESULT