Sum Unique Values in a Pivot Table

  • Thread starter Thread starter Anthony
  • Start date Start date
A

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
 
Have you tried puting the Server Name and CPUs as row labels and the Sum of
Concurrent Access as the value for the Pivot Table?

I think it will return what you are seeking.

Good Luck.
 
Back
Top