Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Pivot Table per Unit Records
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Pivot Table per Unit Records
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--- -- RyGuy "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - There are too many records to complete this operatio | Excel Discussion (Misc queries) | |||
unique records in pivot table | Excel Discussion (Misc queries) | |||
Deselecting records in pivot table automatically | Excel Discussion (Misc queries) | |||
unique records in Pivot Table | Excel Discussion (Misc queries) | |||
"How do I get rid of old records in an Pivot Table? | Excel Discussion (Misc queries) |