Sum Pivot Table per Unit Records

[Anthony]

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

 

[ryguy7272]

Pivot Tables are great for many things, but sometimes you need to supplement
your PT data with data that resides outside of the PT. So, maybe you should
do this outside of the Pivot Table:
With Larry and other stuff in Column 1
With Larry1 and other stuff in Column 2
With the 8's and other stuff in other stuff in Column 3

Try these functions:
=SUMPRODUCT(--(A1:A9="LARRY"),C1:C9)
=SUMPRODUCT(--(A1:A9="LARRY"))

Does that work for you?
Regards,
Ryan---