Spreadsheet: 81988d1282069389-only-one-entry-per-month-in-pivot-table-performance-new
Sheet: Pivot Table

Sum of Delays |  | Delay Cause
Comm | Month | Locomotive | Lost Time | Production | Terminal | Traincrew | Unit | Wagon | Grand Total
B | 2010-07-28 00:00:00 |  |  |  | 64 |  |  |  | 64
 | 2010-07-29 00:00:00 |  |  |  | 3 |  |  |  | 3
 | 2010-08-02 00:00:00 |  |  |  | 4 |  |  |  | 4
 | 2010-08-05 00:00:00 |  |  |  | 3 |  |  |  | 3
 | 2010-08-07 00:00:00 |  |  |  | 6 |  |  |  | 6
B Total |  |  |  |  | 80 |  |  |  | 80
C | 2010-07-26 00:00:00 | 5 | 14 |  | 6 |  |  |  | 25
 | 2010-07-27 00:00:00 |  | 22 |  | 3 |  |  |  | 25
 | 2010-07-28 00:00:00 |  | 58 |  |  |  |  |  | 58
 | 2010-07-29 00:00:00 |  | 34 |  |  |  |  |  | 34
 | 2010-07-30 00:00:00 |  | 10 |  | 5 |  |  |  | 15
 | 2010-07-31 00:00:00 |  | 3 |  |  |  |  |  | 3
 | 2010-08-02 00:00:00 |  |  |  |  |  |  | 21 | 21
 | 2010-08-03 00:00:00 |  | 11 |  | 32 |  |  |  | 43
 | 2010-08-04 00:00:00 |  | 9 |  | 12 |  |  |  | 21
 | 2010-08-05 00:00:00 |  | 24 |  |  |  |  |  | 24
 | 2010-08-06 00:00:00 | 18 | 4 |  |  | 7 |  |  | 29
 | 2010-08-07 00:00:00 |  | 3 |  |  |  |  |  | 3
C Total |  | 23 | 192 |  | 58 | 7 |  | 21 | 301
D | 2010-08-02 00:00:00 |  | 4 |  |  |  |  |  | 4
D Total |  |  | 4 |  |  |  |  |  | 4
F | 2010-07-26 00:00:00 |  |  |  | 125 |  |  |  | 125
 | 2010-07-28 00:00:00 |  |  |  |  | 16 |  |  | 16
 | 2010-07-29 00:00:00 |  |  |  | 19 |  |  |  | 19
 | 2010-07-30 00:00:00 |  |  |  | 3 |  |  |  | 3
 | 2010-08-06 00:00:00 |  | 4 |  |  |  |  |  | 4
F Total |  |  | 4 |  | 147 | 16 |  |  | 167
G | 2010-07-26 00:00:00 | 32 | 6 |  |  |  |  |  | 38
 | 2010-07-27 00:00:00 | 6 |  |  |  |  |  |  | 6
 | 2010-07-28 00:00:00 |  |  |  | 5 |  |  |  | 5
 | 2010-07-30 00:00:00 |  |  |  |  | 3 |  |  | 3
 | 2010-08-02 00:00:00 |  |  |  | 4 |  |  |  | 4
 | 2010-08-03 00:00:00 | 25 |  |  | 10 |  |  |  | 35
 | 2010-08-05 00:00:00 |  |  |  | 10 | 10 |  |  | 20
 | 2010-08-06 00:00:00 |  | 4 |  | 69 |  |  |  | 73
G Total |  | 63 | 10 |  | 98 | 13 |  |  | 184
N | 2010-07-25 00:00:00 |  |  |  | 25 |  |  |  | 25
 | 2010-07-26 00:00:00 |  |  |  | 89 | 4 |  |  | 93
 | 2010-07-27 00:00:00 |  |  |  | 45 |  |  |  | 45
 | 2010-07-28 00:00:00 |  |  |  | 51 |  |  |  | 51
 | 2010-07-29 00:00:00 |  |  | 6 | 10 | 4 |  |  | 20
 | 2010-07-30 00:00:00 |  |  |  | 26 | 3 |  |  | 29
 | 2010-07-31 00:00:00 |  |  | 3 |  |  |  |  | 3
 | 2010-08-02 00:00:00 |  | 6 |  | 45 | 7 |  |  | 58
 | 2010-08-03 00:00:00 | 10 |  |  |  | 3 |  |  | 13
 | 2010-08-04 00:00:00 |  |  |  |  | 7 |  |  | 7
 | 2010-08-05 00:00:00 |  |  |  | 3 |  |  |  | 3
 | 2010-08-06 00:00:00 |  |  |  | 8 |  |  |  | 8
N Total |  | 10 | 6 | 9 | 302 | 28 |  |  | 355
S | 2010-07-27 00:00:00 |  |  |  | 15 | 27 |  |  | 42
 | 2010-07-28 00:00:00 |  |  |  | 25 |  |  |  | 25
 | 2010-07-29 00:00:00 |  |  |  | 3 |  |  |  | 3
 | 2010-08-03 00:00:00 |  |  |  | 4 |  |  |  | 4
 | 2010-08-05 00:00:00 |  |  | 3 |  |  |  |  | 3
 | 2010-08-06 00:00:00 |  |  |  |  |  | 3 |  | 3
 | 2010-08-07 00:00:00 | 26 |  |  |  |  |  |  | 26
S Total |  | 26 |  | 3 | 47 | 27 | 3 |  | 106
Z | 2010-07-27 00:00:00 |  |  |  |  | 28 |  |  | 28
Z Total |  |  |  |  |  | 28 |  |  | 28
Grand Total |  | 122 | 216 | 12 | 732 | 119 | 3 | 21 | 1225