Spreadsheet: 158979d1338470765-extracting-data-related-to-a-single-month-from-a-whole-range-of-data-pivot-table-problem1
Sheet: D

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
 | d |  |  |  | d Total | Grand Total |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  | d Total | Grand Total |  |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  | d Total | Grand Total |  |  |  |  | d |  |  | d Total | Grand Total |  |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  | d Total | Grand Total |  |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  | d Total | Grand Total |  |  |  | d |  | d Total | Grand Total |  |  |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  |  | d Total | Grand Total |  |  | d |  |  |  | d Total | Grand Total
Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 |  |  |  |  |  | Row Labels | 0 | 50 | 100 |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 100 | a |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | a |  |  |  |  | Row Labels | 0 | a |  |  |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a |  |  |  | Row Labels | 0 | 50 | 100 | a
2012-02-01 00:00:00 | 10 |  |  |  | 10 | 10 |  | 2012-02-02 00:00:00 |  |  |  | 5 | 5 | 5 |  | 2012-02-02 00:00:00 |  | 5 |  | 5 | 5 |  |  | 2012-02-15 00:00:00 |  | 45 |  |  | 45 | 45 |  | 2012-02-02 00:00:00 |  |  |  | 6 | 6 | 6 |  | 2012-02-06 00:00:00 |  | 5 |  |  | 5 | 5 |  | 2012-02-17 00:00:00 | 2 |  | 2 | 2 |  |  |  | 2012-02-20 00:00:00 | 2 |  |  | 2 | 2 |  |  | 2012-02-16 00:00:00 |  |  |  | 44 | 44 | 44 |  | 2012-02-09 00:00:00 |  | 4 |  | 4 | 4 |  |  | 2012-02-06 00:00:00 |  |  |  | 5 | 5 | 5 |  | 2012-02-13 00:00:00 |  |  | 54 | 54 | 54 |  |  | 2012-02-23 00:00:00 | 6 | 25 | 31 | 31 |  |  |  | 2012-02-17 00:00:00 | 1 |  |  |  | 1 | 1 |  | 2012-02-13 00:00:00 |  | 59 |  |  | 59 | 59 |  | 2012-02-13 00:00:00 | 1 |  |  |  | 1 | 1
2012-02-24 00:00:00 |  |  | 11 |  | 11 | 11 |  | 2012-02-16 00:00:00 |  | 8 |  |  | 8 | 8 |  | 2012-02-21 00:00:00 |  |  | 9 | 9 | 9 |  |  | 2012-02-17 00:00:00 | 6 |  |  |  | 6 | 6 |  | 2012-02-15 00:00:00 |  | 4 |  |  | 4 | 4 |  | 2012-02-17 00:00:00 | 1 |  |  |  | 1 | 1 |  | 2012-02-27 00:00:00 |  | 5 | 5 | 5 |  |  |  | 2012-02-22 00:00:00 |  | 12 |  | 12 | 12 |  |  | 2012-02-22 00:00:00 |  | 6 |  |  | 6 | 6 |  | 2012-02-17 00:00:00 |  |  | 5 | 5 | 5 |  |  | 2012-02-10 00:00:00 |  |  | 1 |  | 1 | 1 |  | 2012-02-23 00:00:00 | 1 |  |  | 1 | 1 |  |  | 2012-03-20 00:00:00 | 6 | 4 | 10 | 10 |  |  |  | 2012-02-21 00:00:00 |  |  |  | 2 | 2 | 2 |  | 2012-02-14 00:00:00 | 2 |  |  |  | 2 | 2 |  | 2012-02-22 00:00:00 |  |  |  | 1 | 1 | 1
2012-02-25 00:00:00 |  |  | 58 |  | 58 | 58 |  | 2012-02-29 00:00:00 |  | 96 |  |  | 96 | 96 |  | 2012-02-27 00:00:00 | 6 |  | 5 | 11 | 11 |  |  | 2012-02-22 00:00:00 |  | 1 |  |  | 1 | 1 |  | 2012-02-17 00:00:00 | 1 |  |  |  | 1 | 1 |  | 2012-02-27 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-03-17 00:00:00 | 3 |  | 3 | 3 |  |  |  | 2012-02-29 00:00:00 |  |  | 2 | 2 | 2 |  |  | 2012-03-16 00:00:00 |  |  |  | 5 | 5 | 5 |  | 2012-02-20 00:00:00 |  |  | 5 | 5 | 5 |  |  | 2012-02-20 00:00:00 |  | 59 |  |  | 59 | 59 |  | 2012-02-28 00:00:00 | 5 |  |  | 5 | 5 |  |  | Grand Total | 12 | 29 | 41 | 41 |  |  |  | 2012-02-24 00:00:00 |  |  |  | 2 | 2 | 2 |  | 2012-02-20 00:00:00 | 6 |  |  |  | 6 | 6 |  | 2012-02-24 00:00:00 |  |  | 33 |  | 33 | 33
2012-02-27 00:00:00 |  | 2 | 1 |  | 3 | 3 |  | 2012-03-01 00:00:00 | 14 |  |  |  | 14 | 14 |  | 2012-03-27 00:00:00 |  |  | 2 | 2 | 2 |  |  | 2012-02-27 00:00:00 |  |  | 1 |  | 1 | 1 |  | 2012-02-27 00:00:00 |  |  | 61 |  | 61 | 61 |  | 2012-02-29 00:00:00 | 8 |  |  |  | 8 | 8 |  | 2012-03-27 00:00:00 |  | 51 | 51 | 51 |  |  |  | 2012-03-22 00:00:00 |  |  | 7 | 7 | 7 |  |  | 2012-03-27 00:00:00 | 3 | 21 |  |  | 24 | 24 |  | 2012-02-28 00:00:00 |  |  | 1 | 1 | 1 |  |  | 2012-02-22 00:00:00 |  |  | 8 |  | 8 | 8 |  | 2012-02-29 00:00:00 |  |  | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | 2012-02-28 00:00:00 |  | 68 |  |  | 68 | 68 |  | 2012-02-22 00:00:00 |  |  |  | 18 | 18 | 18 |  | 2012-02-25 00:00:00 |  |  | 1 |  | 1 | 1
2012-03-15 00:00:00 |  |  | 12 |  | 12 | 12 |  | 2012-03-16 00:00:00 |  | 21 |  |  | 21 | 21 |  | Grand Total | 6 | 5 | 16 | 27 | 27 |  |  | 2012-02-28 00:00:00 |  | 5 |  |  | 5 | 5 |  | 2012-02-28 00:00:00 | 1 |  |  |  | 1 | 1 |  | 2012-03-02 00:00:00 | 8 |  |  |  | 8 | 8 |  | 2012-03-28 00:00:00 | 3 |  | 3 | 3 |  |  |  | 2012-03-28 00:00:00 | 56 |  |  | 56 | 56 |  |  | 2012-03-29 00:00:00 |  |  | 12 |  | 12 | 12 |  | 2012-03-06 00:00:00 | 52 |  |  | 52 | 52 |  |  | 2012-02-23 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-03-20 00:00:00 |  |  | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 2012-03-17 00:00:00 | 7 |  |  | 5 | 12 | 12 |  | 2012-02-24 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-02-27 00:00:00 |  |  |  | 2 | 2 | 2
2012-03-21 00:00:00 | 12 |  |  |  | 12 | 12 |  | 2012-03-23 00:00:00 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 2012-03-15 00:00:00 |  | 5 |  |  | 5 | 5 |  | 2012-03-15 00:00:00 |  |  | 5 |  | 5 | 5 |  | 2012-03-06 00:00:00 | 4 |  |  |  | 4 | 4 |  | Grand Total | 8 | 56 | 64 | 64 |  |  |  | 2012-03-29 00:00:00 | 2 | 54 |  | 56 | 56 |  |  | Grand Total | 3 | 27 | 12 | 49 | 91 | 91 |  | 2012-03-23 00:00:00 | 2 |  |  | 2 | 2 |  |  | 2012-02-28 00:00:00 | 5 |  |  |  | 5 | 5 |  | 2012-03-23 00:00:00 |  |  | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 2012-03-28 00:00:00 | 7 |  |  |  | 7 | 7 |  | 2012-02-28 00:00:00 |  | 4 |  |  | 4 | 4 |  | 2012-02-28 00:00:00 |  | 8 |  |  | 8 | 8
2012-03-24 00:00:00 |  |  |  | 2 | 2 | 2 |  | 2012-03-29 00:00:00 |  |  | 4 |  | 4 | 4 |  |  |  |  |  |  |  |  |  | 2012-03-17 00:00:00 |  |  | 62 |  | 62 | 62 |  | 2012-03-21 00:00:00 |  |  | 9 |  | 9 | 9 |  | 2012-03-21 00:00:00 |  |  | 48 |  | 48 | 48 |  |  |  |  |  |  |  |  |  | Grand Total | 60 | 66 | 9 | 135 | 135 |  |  |  |  |  |  |  |  |  |  | Grand Total | 54 | 4 | 11 | 69 | 69 |  |  | 2012-02-29 00:00:00 |  |  |  | 3 | 3 | 3 |  | 2012-03-28 00:00:00 |  | 15 |  | 15 | 15 |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 |  |  | 6 |  | 6 | 6 |  | 2012-03-13 00:00:00 |  |  |  | 5 | 5 | 5 |  | 2012-03-09 00:00:00 |  | 12 |  |  | 12 | 12
2012-03-25 00:00:00 |  |  |  | 5 | 5 | 5 |  | Grand Total | 15 | 125 | 4 | 5 | 149 | 149 |  |  |  |  |  |  |  |  |  | 2012-03-22 00:00:00 |  |  | 1 |  | 1 | 1 |  | 2012-03-22 00:00:00 | 5 |  |  |  | 5 | 5 |  | 2012-03-22 00:00:00 | 6 |  |  |  | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-10 00:00:00 |  |  | 12 |  | 12 | 12 |  | Grand Total | 6 | 15 | 63 | 84 | 84 |  |  |  |  |  |  |  |  |  |  | Grand Total | 15 | 68 | 6 | 9 | 98 | 98 |  | 2012-03-14 00:00:00 | 12 |  |  |  | 12 | 12 |  | 2012-03-22 00:00:00 |  | 12 |  |  | 12 | 12
2012-03-27 00:00:00 |  |  | 6 | 6 | 12 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-27 00:00:00 |  |  |  | 2 | 2 | 2 |  | Grand Total | 7 | 4 | 75 | 6 | 92 | 92 |  | 2012-03-27 00:00:00 |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-13 00:00:00 |  |  | 4 |  | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-22 00:00:00 |  |  |  | 4 | 4 | 4 |  | 2012-03-24 00:00:00 | 1 |  |  |  | 1 | 1
Grand Total | 22 | 2 | 88 | 13 | 125 | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 6 | 56 | 64 | 2 | 128 | 128 |  |  |  |  |  |  |  |  |  | Grand Total | 27 | 5 | 53 | 1 | 86 | 86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-20 00:00:00 |  | 2 |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-24 00:00:00 |  |  |  | 15 | 15 | 15 |  | 2012-03-25 00:00:00 | 2 |  |  |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-22 00:00:00 |  | 5 |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-28 00:00:00 |  |  |  | 7 | 7 | 7 |  | Grand Total | 4 | 32 | 34 | 3 | 73 | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-23 00:00:00 | 5 |  |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 20 | 63 | 5 | 49 | 137 | 137
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 |  | 6 |  |  | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 10 | 72 | 30 | 8 | 120 | 120