how do I make a pivot table in excel to find total fixed asset cost by city?

I have city, the asset, cost, salvage value, depreiation expense, acc dep, and book value.