Spreadsheet: 159175d1338535131-pivot-table-reporting-by-month-and-zero-data-issue-pivot-table-problem1
Sheet: W

Type | a |  |  |  |  |  |  | Type | b |  |  |  |  |  |  | Type | c |  |  |  |  |  |  | Type | d |  |  |  |  |  |  | Type | e |  |  |  |  |  |  | Type | f |  |  |  |  |  |  | Type | g |  |  |  |  |  |  | Type | h |  |  |  |  |  |  | Type | i |  |  |  |  |  |  | Type | j |  |  |  |  |  |  | Type | k |  |  |  |  |  |  | Type | l |  |  |  |  |  |  | Type | m |  |  |  |  |  |  | Type | n |  |  |  |  |  |  | Type | o |  |  |  |  |  |  | Type | p
Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels |  |  |  |  |  |  | Sum of Miles | Column Labels
 | w |  |  |  | w Total | Grand Total |  |  | w |  |  | w Total | Grand Total |  |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  | w Total | Grand Total |  |  |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  | w Total | Grand Total |  |  |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  |  |  | w Total | Grand Total |  |  | w | w Total | Grand Total |  |  |  |  |  | w |  | w Total | Grand Total |  |  |  |  | w |  |  |  | w Total | Grand Total |  |  | w |  |  | w Total | Grand Total |  |  |  | w |  |  | w Total | Grand Total |  |  |  | w |  |  |  | w Total | Grand Total
Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 50 | 100 | a |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 100 | a |  |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 100 |  |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 50 |  |  |  |  |  |  | Row Labels | 100 | a |  |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 |  |  |  |  | Row Labels | 50 | 100 | a |  |  |  |  | Row Labels | 0 | 50 | 100 | a
2012-02-14 00:00:00 | 44 | 6 |  |  | 50 | 50 |  | 2012-02-01 00:00:00 | 5 |  |  | 5 | 5 |  |  | 2012-02-01 00:00:00 |  |  | 2 |  | 2 | 2 |  | 2012-02-02 00:00:00 |  | 3 | 3 | 3 |  |  |  | 2012-02-22 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-02-15 00:00:00 |  | 5 | 5 | 5 |  |  |  | 2012-02-06 00:00:00 |  | 1 |  |  | 1 | 1 |  | 2012-02-08 00:00:00 |  | 4 |  |  | 4 | 4 |  | 2012-02-06 00:00:00 |  | 6 |  |  | 6 | 6 |  | 2012-02-06 00:00:00 |  |  |  | 1 | 1 | 1 |  | 2012-02-17 00:00:00 | 5 | 5 | 5 |  |  |  |  | 2012-02-17 00:00:00 | 1 |  | 1 | 1 |  |  |  | 2012-02-10 00:00:00 |  |  | 2 |  | 2 | 2 |  | 2012-02-13 00:00:00 |  |  | 1 | 1 | 1 |  |  | 2012-02-14 00:00:00 |  | 7 |  | 7 | 7 |  |  | 2012-02-14 00:00:00 | 4 |  |  |  | 4 | 4
2012-02-15 00:00:00 | 55 | 6 |  |  | 61 | 61 |  | 2012-02-21 00:00:00 | 7 |  |  | 7 | 7 |  |  | 2012-02-15 00:00:00 |  | 5 |  |  | 5 | 5 |  | 2012-03-01 00:00:00 | 65 |  | 65 | 65 |  |  |  | 2012-03-22 00:00:00 |  | 19 |  |  | 19 | 19 |  | 2012-02-22 00:00:00 | 7 |  | 7 | 7 |  |  |  | 2012-02-15 00:00:00 |  | 7 |  |  | 7 | 7 |  | 2012-02-15 00:00:00 |  |  |  | 9 | 9 | 9 |  | 2012-02-08 00:00:00 |  | 78 |  |  | 78 | 78 |  | 2012-02-22 00:00:00 |  | 1 |  |  | 1 | 1 |  | 2012-03-14 00:00:00 | 3 | 3 | 3 |  |  |  |  | 2012-02-20 00:00:00 |  | 6 | 6 | 6 |  |  |  | 2012-02-14 00:00:00 |  | 6 |  |  | 6 | 6 |  | 2012-02-14 00:00:00 |  | 9 |  | 9 | 9 |  |  | 2012-02-23 00:00:00 |  | 22 |  | 22 | 22 |  |  | 2012-02-15 00:00:00 |  |  | 1 |  | 1 | 1
2012-02-20 00:00:00 |  |  |  | 6 | 6 | 6 |  | 2012-02-23 00:00:00 |  | 4 |  | 4 | 4 |  |  | 2012-02-17 00:00:00 |  |  | 99 |  | 99 | 99 |  | 2012-03-02 00:00:00 |  | 6 | 6 | 6 |  |  |  | 2012-03-23 00:00:00 | 9 |  |  |  | 9 | 9 |  | Grand Total | 7 | 5 | 12 | 12 |  |  |  | 2012-02-22 00:00:00 |  |  |  | 9 | 9 | 9 |  | 2012-02-27 00:00:00 |  | 2 |  |  | 2 | 2 |  | 2012-02-20 00:00:00 |  |  |  | 95 | 95 | 95 |  | 2012-02-23 00:00:00 |  |  | 8 |  | 8 | 8 |  | Grand Total | 8 | 8 | 8 |  |  |  |  | 2012-03-13 00:00:00 |  | 21 | 21 | 21 |  |  |  | 2012-02-17 00:00:00 |  | 3 |  |  | 3 | 3 |  | 2012-02-23 00:00:00 |  |  | 51 | 51 | 51 |  |  | 2012-02-24 00:00:00 |  | 9 |  | 9 | 9 |  |  | 2012-03-14 00:00:00 | 100 |  |  |  | 100 | 100
2012-02-24 00:00:00 | 25 |  | 9 |  | 34 | 34 |  | 2012-02-27 00:00:00 |  |  | 11 | 11 | 11 |  |  | 2012-03-01 00:00:00 |  | 6 |  |  | 6 | 6 |  | Grand Total | 65 | 9 | 74 | 74 |  |  |  | 2012-03-28 00:00:00 |  |  |  | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  | 2012-02-29 00:00:00 | 1 |  |  |  | 1 | 1 |  | 2012-02-29 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-02-23 00:00:00 |  |  | 4 |  | 4 | 4 |  | 2012-02-29 00:00:00 |  | 2 |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  | Grand Total | 1 | 27 | 28 | 28 |  |  |  | 2012-02-20 00:00:00 |  |  |  | 95 | 95 | 95 |  | 2012-02-29 00:00:00 | 2 |  |  | 2 | 2 |  |  | 2012-02-25 00:00:00 |  | 6 |  | 6 | 6 |  |  | 2012-03-17 00:00:00 | 2 |  |  |  | 2 | 2
2012-02-25 00:00:00 |  |  | 6 |  | 6 | 6 |  | 2012-03-15 00:00:00 |  |  | 5 | 5 | 5 |  |  | 2012-03-17 00:00:00 |  |  | 32 |  | 32 | 32 |  |  |  |  |  |  |  |  |  | Grand Total | 9 | 19 | 5 | 2 | 35 | 35 |  |  |  |  |  |  |  |  |  | 2012-03-06 00:00:00 | 9 |  |  |  | 9 | 9 |  | 2012-03-08 00:00:00 |  | 1 |  |  | 1 | 1 |  | 2012-02-27 00:00:00 | 2 |  |  |  | 2 | 2 |  | 2012-03-06 00:00:00 |  |  |  | 11 | 11 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-28 00:00:00 | 51 |  |  |  | 51 | 51 |  | 2012-03-14 00:00:00 |  | 9 |  | 9 | 9 |  |  | 2012-03-13 00:00:00 |  |  | 4 | 4 | 4 |  |  | 2012-03-20 00:00:00 |  |  |  | 5 | 5 | 5
2012-03-14 00:00:00 | 10 |  |  |  | 10 | 10 |  | 2012-03-27 00:00:00 |  |  | 2 | 2 | 2 |  |  | 2012-03-22 00:00:00 |  |  |  | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-15 00:00:00 |  | 7 | 2 |  | 9 | 9 |  | 2012-03-15 00:00:00 |  |  |  | 9 | 9 | 9 |  | 2012-02-29 00:00:00 |  |  | 1 |  | 1 | 1 |  | 2012-03-20 00:00:00 |  |  |  | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-29 00:00:00 |  |  | 2 |  | 2 | 2 |  | 2012-03-17 00:00:00 |  | 5 | 1 | 6 | 6 |  |  | 2012-03-24 00:00:00 | 54 | 4 |  | 58 | 58 |  |  | 2012-03-24 00:00:00 | 51 |  |  |  | 51 | 51
2012-03-15 00:00:00 | 5 | 5 |  |  | 10 | 10 |  | Grand Total | 12 | 4 | 18 | 34 | 34 |  |  | 2012-03-23 00:00:00 | 5 |  |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 |  | 32 |  |  | 32 | 32 |  | 2012-03-20 00:00:00 | 4 |  |  |  | 4 | 4 |  | 2012-03-06 00:00:00 |  |  |  | 2 | 2 | 2 |  | 2012-03-28 00:00:00 |  | 21 |  |  | 21 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-10 00:00:00 |  | 3 |  |  | 3 | 3 |  | Grand Total | 2 | 23 | 53 | 78 | 78 |  |  | 2012-03-25 00:00:00 |  |  | 12 | 12 | 12 |  |  | 2012-03-28 00:00:00 |  | 8 |  |  | 8 | 8
2012-03-20 00:00:00 |  |  |  | 7 | 7 | 7 |  |  |  |  |  |  |  |  |  | 2012-03-27 00:00:00 |  | 1 |  | 8 | 9 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 10 | 47 | 2 | 9 | 68 | 68 |  | 2012-03-22 00:00:00 |  |  | 12 |  | 12 | 12 |  | 2012-03-08 00:00:00 |  | 20 |  |  | 20 | 20 |  | 2012-03-29 00:00:00 | 1 |  |  | 5 | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | 3 |  |  |  | 3 | 3 |  |  |  |  |  |  |  |  |  | Grand Total | 54 | 48 | 16 | 118 | 118 |  |  | Grand Total | 157 | 8 | 1 | 5 | 171 | 171
2012-03-24 00:00:00 | 6 | 5 |  |  | 11 | 11 |  |  |  |  |  |  |  |  |  | Grand Total | 5 | 12 | 133 | 13 | 163 | 163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 |  |  |  | 2 | 2 | 2 |  | 2012-03-14 00:00:00 |  |  |  | 46 | 46 | 46 |  | Grand Total | 1 | 24 | 8 | 21 | 54 | 54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-17 00:00:00 |  | 3 |  |  | 3 | 3
2012-03-25 00:00:00 | 12 | 12 |  |  | 24 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 4 | 7 | 17 | 20 | 48 | 48 |  | 2012-03-22 00:00:00 |  | 21 |  |  | 21 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-20 00:00:00 |  |  |  | 3 | 3 | 3
2012-03-27 00:00:00 |  | 4 |  |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-23 00:00:00 |  |  | 15 |  | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-23 00:00:00 | 3 | 45 |  |  | 48 | 48
Grand Total | 157 | 38 | 15 | 13 | 223 | 223 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-27 00:00:00 |  | 23 |  |  | 23 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-28 00:00:00 | 10 |  |  |  | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 2 | 148 | 20 | 143 | 313 | 313 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 | 4 |  |  |  | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 71 | 60 | 4 | 98 | 233 | 233