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 |
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) |