Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I tried asking this earlier, but did not phrase it well. I am having
problems summarizing a list of the following data into a pivot table. The data are for times between various order processing activities. I'd like to develop a pivot table delineating the number of occurances (spread) by minute for each of these three tasks. I can do a pivot table for each of them, but not one master one with the minutes at the top of the pivot table, and occurances by minute for each of the three steps below it. Any thoughts or directions for me to follow? Each Occurances: Order" Collect" Receipt" 5 4 9 4 0 4 14 5 20 18 1 19 4 2 6 1 4 5 1 3 3 1 0 2 €¦ €¦ €¦ I'd like the table to look something like this: minutes 0" 1" 2" 3" €¦ # Order # Collect # Receipt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table questions | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |