Hello

I have a spreadsheet with several records for each machine's name as
illustrated below:

Server Name / Database Instance Name / CPUs / Concurrent Access
__________________________________________________ ____________
Larry / Larry1 / 8 / 5
Larry / Larry2 / 8 / 50
Larry / Larry3 / 8 / 10
Larry / Larry4 / 8 / 1
Amy / Amy1 / 2 / 10
Amy / Amy2 / 2 / 5
Amy / Amy3 / 2 / 35
Larry / Larry1 / 16 / 500
Derron / Derron / 6 / 25

I want to have pivot tables with "Server Name" in a ROW and two DATA fields:
- Data field 1 : a sum of the total "Concurrent Access" for all database
instances on the Server (i.e. 5+50+10= 65 for Larry)
- Data field 2 : a sum of "CPUs" per unique occurrences of Server Name (i.e.
8 for Larry and not 8+8+8)

Is there some way to do that in a pivot table?

Thanks