Spreadsheet: 126107d1319530425-excel-2007-pivot-table-convert-dd-mm-yyyy-to-mm-yyyy-copy1
Sheet: date

SKU | Description | Qty | Date
 |  |  |  |  |  | Sum of Qty |  | Column Labels
1 |  | 48 | 2011-10-12 00:00:00 |  |  | Row Labels | Description | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 00:00:00 | 2011-11-11 00:00:00 | 2012-03-12 00:00:00 | 2012-02-12 00:00:00 | Grand Total
2 |  | 345 | 2011-10-20 00:00:00 |  |  | 4 | (blank) |  |  |  | 252 |  |  | 252
3 |  | 36 | 2011-10-31 00:00:00 |  |  | 5 | (blank) | 288 |  |  |  |  |  | 288
4 |  | 252 | 2011-11-11 00:00:00 |  |  | 6 | (blank) | 72 |  |  |  |  |  | 72
5 |  | 288 | 2012-01-01 00:00:00 |  |  | 15 | (blank) |  | 156 |  |  |  |  | 156
6 |  | 72 | 2012-01-01 00:00:00 |  |  | 16 | (blank) |  | 60 |  |  |  |  | 60
7 |  | 500 | 2012-01-09 00:00:00 |  |  | 19 | (blank) |  |  |  |  |  | 520 | 520
8 |  | 588 | 2012-01-09 00:00:00 |  |  | 20 | (blank) |  |  |  |  |  | 38 | 38
9 |  | 576 | 2012-01-14 00:00:00 |  |  | 28 | (blank) |  |  |  |  | 576 |  | 576
10 |  | 1008 | 2012-01-16 00:00:00 |  |  | 29 | (blank) |  |  |  |  | 264 |  | 264
11 |  | 684 | 2012-01-16 00:00:00 |  |  | 87 | (blank) |  |  | 0 |  |  |  | 0
12 |  | 322 | 2012-01-22 00:00:00 |  |  | Grand Total |  | 360 | 216 | 0 | 252 | 840 | 558 | 2226
13 |  | 720 | 2012-01-26 00:00:00
14 |  | 379 | 2012-01-31 00:00:00
15 |  | 156 | 2012-02-01 00:00:00
16 |  | 60 | 2012-02-01 00:00:00
17 |  | 172 | 2012-02-05 00:00:00
18 |  | 496 | 2012-02-10 00:00:00
19 |  | 520 | 2012-02-12 00:00:00
20 |  | 38 | 2012-02-12 00:00:00
21 |  | 221 | 2012-02-17 00:00:00
22 |  | 60 | 2012-03-04 00:00:00
23 |  | 570 | 2012-03-04 00:00:00
24 |  | 288 | 2012-03-06 00:00:00
25 |  | 192 | 2012-03-06 00:00:00
26 |  | 24 | 2012-03-10 00:00:00
27 |  | 612 | 2012-03-11 00:00:00
28 |  | 576 | 2012-03-12 00:00:00
29 |  | 264 | 2012-03-12 00:00:00
30 |  | 600 | 2012-03-13 00:00:00
31 |  | 108 | 2012-03-30 00:00:00
32 |  | 960 | 2012-03-31 00:00:00
33 |  | 300 | 2012-04-01 00:00:00
34 |  | 521 | 2012-04-06 00:00:00
35 |  | 612 | 2012-04-07 00:00:00
36 |  | 660 | 2012-04-08 00:00:00
37 |  | 625 | 2012-04-10 00:00:00
38 |  | 880 | 2012-04-27 00:00:00
39 |  | 360 | 2012-04-27 00:00:00
40 |  | 465 | 2012-04-29 00:00:00
41 |  | 304 | 2012-04-30 00:00:00
42 |  | 144 | 2012-05-01 00:00:00
43 |  | 660 | 2012-05-02 00:00:00
44 |  | 1620 | 2012-05-09 00:00:00
45 |  | 396 | 2012-05-09 00:00:00
46 |  | 300 | 2012-05-13 00:00:00
47 |  | 528 | 2012-05-20 00:00:00
48 |  | 625 | 2012-05-27 00:00:00
49 |  | 625 | 2012-05-27 00:00:00
50 |  | 625 | 2012-05-27 00:00:00
51 |  | 625 | 2012-05-27 00:00:00
52 |  | 625 | 2012-05-27 00:00:00
53 |  | 625 | 2012-05-27 00:00:00
54 |  | 625 | 2012-05-27 00:00:00
55 |  | 625 | 2012-05-27 00:00:00
56 |  | 625 | 2012-05-27 00:00:00
57 |  | 625 | 2012-05-27 00:00:00
58 |  | 625 | 2012-05-27 00:00:00
59 |  | 625 | 2012-05-27 00:00:00
60 |  | 625 | 2012-05-27 00:00:00
61 |  | 625 | 2012-05-27 00:00:00
62 |  | 625 | 2012-05-27 00:00:00
63 |  | 683 | 2012-05-27 00:00:00
64 |  | 528 | 2012-05-31 00:00:00
65 |  | 912 | 2012-05-31 00:00:00
66 |  | 330 | 2012-06-06 00:00:00
67 |  | 800 | 2012-06-19 00:00:00
68 |  | 1560 | 2012-06-20 00:00:00
69 |  | 419 | 2012-06-22 00:00:00
70 |  | 378 | 2012-06-30 00:00:00
71 |  | 220 | 2012-06-30 00:00:00
72 |  | 270 | 2012-06-30 00:00:00
73 |  | 1680 | 2012-07-05 00:00:00
74 |  | 517 | 2012-07-05 00:00:00
75 |  | 306 | 2012-07-09 00:00:00
76 |  | 800 | 2012-07-25 00:00:00
77 |  | 375 | 2012-08-22 00:00:00
78 |  | 2 | 2012-09-30 00:00:00
79 |  | 840 | 2012-10-11 00:00:00
80 |  | 780 | 2012-10-11 00:00:00
81 |  | 301 | 2012-11-11 00:00:00
82 |  | 432 | 2012-11-24 00:00:00
83 |  | 1560 | 2012-12-11 00:00:00
84 |  | 1680 | 2012-12-14 00:00:00
85 |  | 608 | 2012-12-14 00:00:00
86 |  | 440 | 2011-12-25 00:00:00
87 |  | 0 | 00:00:00