How to get no of documents in a particular category

Hi ,I am creating a view in that i have these columns total,city ,name,Address.In this city is categorized I need to get total persons in a particular city and display it in total column and export it to excel.

can any one help in this.

thanks

Subject: how to get no of documents in a particular category

You can do this by browsing through a NotesViewNavigator and check for the category entries. The easiest way to get your information is to dump the contents of all columns of each row (or at least a sufficient number of rows) and then you will notice the pattern of the categorized views.