G
Guest
I have a rather large table with the following columns:
MACHINE ID#
MACHINE NAME
TIME DOWN
LOST CAPACITY
("Machine ID" is discrete, "Machine Name" is not. In other words, Machine 1
and Machine 2 can both be "Jeep").
I'd like to:
Sort by Machine ID
Get a subtotal of Time Down
Get a subtotal of Lost Capacity
Get a COUNT of how many entries there are for each ID
Listed by Machine Name and ID.
In other words:
RAW DATA
ID NAME TIME CAPACITY
1 Jeep 4 20
1 Jeep 5 25
1 Jeep 6 30
2 Jeep 10 120
2 Jeep 18 150
3 Vette 40 28
3 Vette 42 28
REPORT
ID NAME TIME CAPACITY n
1 Jeep 15 75 3
2 Jeep 28 270 2
3 Vette 82 56 2
The best I've been able to do is:
ID NAME TIME CAPACITY
1 SUBTOTAL 15 75
1 COUNT 3 3 3
2 SUBTOTAL 28 270
2 COUNT 2 2 2
I've figured out how to make the sums pretty with Pivot Tables, but the
counts?
I have 300 machine ID's and over 5000 line item entries, so easy and elegant
is the order of the day!!
Thanks
MACHINE ID#
MACHINE NAME
TIME DOWN
LOST CAPACITY
("Machine ID" is discrete, "Machine Name" is not. In other words, Machine 1
and Machine 2 can both be "Jeep").
I'd like to:
Sort by Machine ID
Get a subtotal of Time Down
Get a subtotal of Lost Capacity
Get a COUNT of how many entries there are for each ID
Listed by Machine Name and ID.
In other words:
RAW DATA
ID NAME TIME CAPACITY
1 Jeep 4 20
1 Jeep 5 25
1 Jeep 6 30
2 Jeep 10 120
2 Jeep 18 150
3 Vette 40 28
3 Vette 42 28
REPORT
ID NAME TIME CAPACITY n
1 Jeep 15 75 3
2 Jeep 28 270 2
3 Vette 82 56 2
The best I've been able to do is:
ID NAME TIME CAPACITY
1 SUBTOTAL 15 75
1 COUNT 3 3 3
2 SUBTOTAL 28 270
2 COUNT 2 2 2
I've figured out how to make the sums pretty with Pivot Tables, but the
counts?
I have 300 machine ID's and over 5000 line item entries, so easy and elegant
is the order of the day!!
Thanks