Actually, I think the pivot table is fine.. the problem lies with me.
I use a spreadsheet to manage staffing at events. I have various staff at an event and create a row for each person that has the event number and city and so on (see attached). I wanted to use a pivot table to see how many events were performed per city but what I get is the count of staff used at each city.
In the attached worksheet, I have some sample data - the answer is one event per city but as you can see, I don't get that. I want to continue managing the staff this way (until I find something better) but need to be able to look at the data as I need.
i would appreciate any help.