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