Sum Unique Values in a Pivot Table

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

NDPard
Tue May 06 11:06:00 CDT 2008

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.

"Anthony" wrote:

> 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