Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - 3 columns turn-around-times
Good day all! I'm a bit dense today, and would like an insight...
I have a table with three columns of turn-around-times, where I am counting elapsed time in five minute increments for each occurance (1=5", 2=10", etc.). I'd like to summarize each of the three TAT's by the elapsed 5" increments. The goal would be to have pivot table and graph showing the spread of TAT's for each of the three categories. Thoughts? SAMPLE: O-D @ 5" D-R @ 5" O-R @ 5" 10 4 14 8 4 12 3 3 6 3 3 6 3 3 6 3 3 6 12 - 12 (7) 7 - 3 - 3 (45) 44 - (14) 15 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How turn on Classic Pivot Table Settings | Charts and Charting in Excel | |||
How do you turn off pivot table auto format in Excel? | Excel Discussion (Misc queries) | |||
Pivot Table for 3 columns of elapsed times | Excel Discussion (Misc queries) | |||
How to turn off dragging for a Pivot Table field | Excel Programming | |||
How to turn off dragging for a Pivot Table field | Excel Programming |