Get count from table column on crystal report

See more:

CrystalReports

reporting

I'm stuck with getting count of different values of same column. in crystal report i actually want only records with one specific condition; like records of city = "NY"

but i have to show each and every individual count values at the bottom.

like; Washigton 5
Dilhi 6
Shanghai 3

like wise.

so need help to sort this matter out guys.

What I have tried:

i tried get each value count using summary but it didn't work. i tried setting new formula Fields with queries and it also did'nt work for me.

i am using Crystal Report XI Release 2 Version