Spreadsheet: 147737d1332951161-excel-2010-pivot-table-test2
Sheet: Pivot

 | Values
Row Labels | Incidents Logged | Incidents Resolved
<27/07/2010
(blank)
(blank)
2010
Jul | 2 | 1
125 | 1 | 1
134 | 1
Aug | 18 | 15
135 | 1 | 1
155 | 1 | 1
163 | 1 | 1
183 | 1 | 1
187 | 1
206 | 1 | 1
221 | 1 | 1
226 | 1 | 1
227 | 1
241 | 1 | 1
244 | 1 | 1
248 | 1 | 1
252 | 1 | 1
255 | 1 | 1
256 | 1
258 | 1 | 1
271 | 1 | 1
279 | 1 | 1
Sep | 8 | 8
342 | 1 | 1
352 | 1 | 1
375 | 1 | 1
377 | 1 | 1
391 | 1 | 1
403 | 1 | 1
420 | 1 | 1
424 | 1 | 1
Oct | 27 | 26
431 | 1 | 1
440 | 1
441 | 1 | 1
446 | 1 | 1
455 | 1 | 1
461 | 1 | 1
464 | 1 | 1
490 | 1 | 1
505 | 1 | 1
516 | 1 | 1
531 | 1 | 1
533 | 1 | 1
535 | 1 | 1
536 | 1 | 1
547 | 1 | 1
553 | 1 | 1
572 | 1 | 1
585 | 1 | 1
587 | 1 | 1
597 | 1 | 1
598 | 1 | 1
604 | 1 | 1
606 | 1 | 1
609 | 1 | 1
613 | 1 | 1
615 | 1 | 1
675 | 1 | 1
Nov | 34 | 33
632 | 1 | 1
638 | 1 | 1
665 | 1 | 1
667 | 1 | 1
668 | 1 | 1
672 | 1 | 1
690 | 1 | 1
707 | 1 | 1
710 | 1 | 1
715 | 1
720 | 1 | 1
728 | 1 | 1
733 | 1 | 1
738 | 1 | 1
742 | 1 | 1
758 | 1 | 1
762 | 1 | 1
763 | 1 | 1
764 | 1 | 1
768 | 1 | 1
772 | 1 | 1
773 | 1 | 1
778 | 1 | 1
779 | 1 | 1
785 | 1 | 1
800 | 1 | 1
803 | 1 | 1
812 | 1 | 1
820 | 1 | 1
836 | 1 | 1
839 | 1 | 1
849 | 1 | 1
860 | 1 | 1
867 | 1 | 1
Dec | 21 | 20
872 | 1 | 1
875 | 1 | 1
897 | 1 | 1
899 | 1 | 1
901 | 1 | 1
929 | 1 | 1
956 | 1 | 1
958 | 1 | 1
970 | 1
973 | 1 | 1
986 | 1 | 1
990 | 1 | 1
992 | 1 | 1
998 | 1 | 1
1002 | 1 | 1
1008 | 1 | 1
1018 | 1 | 1
1036 | 1 | 1
1042 | 1 | 1
1063 | 1 | 1
1070 | 1 | 1
2011
Jan | 22 | 22
1093 | 1 | 1
1098 | 1 | 1
1099 | 1 | 1
1108 | 1 | 1
1109 | 1 | 1
1115 | 1 | 1
1122 | 1 | 1
1128 | 1 | 1
1133 | 1 | 1
1141 | 1 | 1
1147 | 1 | 1
1150 | 1 | 1
1151 | 1 | 1
1187 | 1 | 1
1196 | 1 | 1
1220 | 1 | 1
1225 | 1 | 1
1230 | 1 | 1
1231 | 1 | 1
1240 | 1 | 1
1251 | 1 | 1
1264 | 1 | 1
Feb | 16 | 14
1270 | 1 | 1
1278 | 1 | 1
1302 | 1 | 1
1317 | 1
1333 | 1 | 1
1334 | 1 | 1
1340 | 1 | 1
1359 | 1 | 1
1374 | 1 | 1
1397 | 1
1408 | 1 | 1
1434 | 1 | 1
1491 | 1 | 1
1495 | 1 | 1
1514 | 1 | 1
1529 | 1 | 1
Mar | 18 | 16
1672 | 1 | 1
1684 | 1 | 1
1685 | 1 | 1
1712 | 1 | 1
1765 | 1 | 1
1814 | 1
1836 | 1 | 1
1856 | 1 | 1
1858 | 1 | 1
1919 | 1 | 1
1995 | 1 | 1
1997 | 1 | 1
2011 | 1 | 1
2061 | 1 | 1
2064 | 1 | 1
2065 | 1
2090 | 1 | 1
5417 | 1 | 1
Apr | 14 | 12
2125 | 1 | 1
2126 | 1
2253 | 1 | 1
2262 | 1
2306 | 1 | 1
2402 | 1 | 1
2440 | 1 | 1
2484 | 1 | 1
2500 | 1 | 1
2687 | 1 | 1
2723 | 1 | 1
2765 | 1 | 1
2766 | 1 | 1
2775 | 1 | 1
May | 24 | 23
2960 | 1 | 1
2966 | 1 | 1
3026 | 1 | 1
3044 | 1 | 1
3046 | 1 | 1
3057 | 1 | 1
3065 | 1 | 1
3093 | 1 | 1
3103 | 1 | 1
3136 | 1 | 1
3173 | 1 | 1
3207 | 1 | 1
3231 | 1 | 1
3248 | 1
3256 | 1 | 1
3269 | 1 | 1
3378 | 1 | 1
3423 | 1 | 1
3439 | 1 | 1
3440 | 1 | 1
3453 | 1 | 1
3488 | 1 | 1
3491 | 1 | 1
3495 | 1 | 1
Jun | 51 | 39
3535 | 1
3536 | 1 | 1
3538 | 1
3544 | 1 | 1
3555 | 1 | 1
3590 | 1 | 1
3614 | 1
3615 | 1 | 1
3636 | 1 | 1
3639 | 1
3662 | 1 | 1
3671 | 1 | 1
3672 | 1
3677 | 1
3689 | 1 | 1
3762 | 1 | 1
3765 | 1
3776 | 1 | 1
3795 | 1 | 1
3811 | 1 | 1
3815 | 1 | 1
3816 | 1 | 1
3846 | 1 | 1
3851 | 1 | 1
3868 | 1 | 1
3871 | 1 | 1
3875 | 1 | 1
3887 | 1 | 1
3901 | 1 | 1
3903 | 1 | 1
3910 | 1 | 1
3921 | 1 | 1
3955 | 1 | 1
3985 | 1 | 1
4019 | 1 | 1
4022 | 1 | 1
4048 | 1 | 1
4054 | 1 | 1
4084 | 1 | 1
4096 | 1 | 1
4102 | 1 | 1
4110 | 1 | 1
4113 | 1 | 1
4117 | 1 | 1
4119 | 1 | 1
4131 | 1 | 1
4249 | 1
4253 | 1
4254 | 1
5035 | 1
5037 | 1
Jul | 50 | 44
4187 | 1 | 1
4209 | 1 | 1
4220 | 1 | 1
4233 | 1
4234 | 1
4235 | 1
4236 | 1
4245 | 1
4251 | 1 | 1
4264 | 1 | 1
4270 | 1
4283 | 1 | 1
4284 | 1 | 1
4352 | 1 | 1
4358 | 1 | 1
4375 | 1 | 1
4388 | 1 | 1
4424 | 1 | 1
4449 | 1 | 1
4478 | 1 | 1
4493 | 1 | 1
4955 | 1 | 1
4957 | 1 | 1
4958 | 1 | 1
4977 | 1 | 1
5014 | 1 | 1
5015 | 1 | 1
5016 | 1 | 1
5022 | 1 | 1
5027 | 1 | 1
5081 | 1 | 1
5171 | 1 | 1
5220 | 1 | 1
5270 | 1 | 1
5309 | 1 | 1
5334 | 1 | 1
5375 | 1 | 1
5376 | 1 | 1
5379 | 1 | 1
5383 | 1 | 1
5399 | 1 | 1
5406 | 1 | 1
5409 | 1 | 1
5435 | 1 | 1
5491 | 1 | 1
5496 | 1 | 1
5516 | 1 | 1
5517 | 1 | 1
5532 | 1 | 1
5552 | 1 | 1
Aug | 40 | 40
5592 | 1 | 1
5605 | 1 | 1
5608 | 1 | 1
5638 | 1 | 1
5639 | 1 | 1
5659 | 1 | 1
5768 | 1 | 1
5797 | 1 | 1
5814 | 1 | 1
5831 | 1 | 1
5849 | 1 | 1
5853 | 1 | 1
5903 | 1 | 1
5928 | 1 | 1
5975 | 1 | 1
6016 | 1 | 1
6048 | 1 | 1
6069 | 1 | 1
6084 | 1 | 1
6089 | 1 | 1
6110 | 1 | 1
6135 | 1 | 1
6203 | 1 | 1
6240 | 1 | 1
6292 | 1 | 1
6340 | 1 | 1
6395 | 1 | 1
6405 | 1 | 1
6463 | 1 | 1
6479 | 1 | 1
6507 | 1 | 1
6511 | 1 | 1
6528 | 1 | 1
6583 | 1 | 1
6606 | 1 | 1
6614 | 1 | 1
6671 | 1 | 1
6676 | 1 | 1
6678 | 1 | 1
6690 | 1 | 1
Sep | 44 | 44
6726 | 1 | 1
6743 | 1 | 1
6755 | 1 | 1
6759 | 1 | 1
6769 | 1 | 1
6770 | 1 | 1
6779 | 1 | 1
6810 | 1 | 1
6829 | 1 | 1
6840 | 1 | 1
6882 | 1 | 1
6904 | 1 | 1
6910 | 1 | 1
6954 | 1 | 1
6986 | 1 | 1
6995 | 1 | 1
7023 | 1 | 1
7065 | 1 | 1
7072 | 1 | 1
7077 | 1 | 1
7079 | 1 | 1
7084 | 1 | 1
7089 | 1 | 1
7136 | 1 | 1
7173 | 1 | 1
7273 | 1 | 1
7276 | 1 | 1
7310 | 1 | 1
7311 | 1 | 1
7353 | 1 | 1
7378 | 1 | 1
7441 | 1 | 1
7511 | 1 | 1
7514 | 1 | 1
7520 | 1 | 1
7526 | 1 | 1
7528 | 1 | 1
7533 | 1 | 1
7574 | 1 | 1
7617 | 1 | 1
7620 | 1 | 1
7716 | 1 | 1
7725 | 1 | 1
7731 | 1 | 1
Oct | 41 | 40
7740 | 1 | 1
7745 | 1 | 1
7751 | 1 | 1
7770 | 1 | 1
7771 | 1 | 1
7808 | 1 | 1
7838 | 1 | 1
7862 | 1 | 1
7865 | 1 | 1
7873 | 1 | 1
7906 | 1 | 1
7918 | 1 | 1
7933 | 1 | 1
7942 | 1
7984 | 1 | 1
7985 | 1 | 1
7998 | 1 | 1
7999 | 1 | 1
8036 | 1 | 1
8039 | 1 | 1
8049 | 1 | 1
8075 | 1 | 1
8085 | 1 | 1
8148 | 1 | 1
8158 | 1 | 1
8182 | 1 | 1
8238 | 1 | 1
8275 | 1 | 1
8332 | 1 | 1
8341 | 1 | 1
8380 | 1 | 1
8399 | 1 | 1
8416 | 1 | 1
8438 | 1 | 1
8464 | 1 | 1
8501 | 1 | 1
8504 | 1 | 1
8517 | 1 | 1
8537 | 1 | 1
8575 | 1 | 1
8579 | 1 | 1
Nov | 52 | 52
8616 | 1 | 1
8627 | 1 | 1
8632 | 1 | 1
8648 | 1 | 1
8687 | 1 | 1
8693 | 1 | 1
8710 | 1 | 1
8716 | 1 | 1
8725 | 1 | 1
8738 | 1 | 1
8756 | 1 | 1
8757 | 1 | 1
8767 | 1 | 1
8771 | 1 | 1
8773 | 1 | 1
8813 | 1 | 1
8816 | 1 | 1
8853 | 1 | 1
8865 | 1 | 1
8874 | 1 | 1
8878 | 1 | 1
8887 | 1 | 1
8892 | 1 | 1
8894 | 1 | 1
8899 | 1 | 1
8973 | 1 | 1
9035 | 1 | 1
9110 | 1 | 1
9122 | 1 | 1
9145 | 1 | 1
9154 | 1 | 1
9155 | 1 | 1
9187 | 1 | 1
9188 | 1 | 1
9191 | 1 | 1
9197 | 1 | 1
9207 | 1 | 1
9224 | 1 | 1
9244 | 1 | 1
9246 | 1 | 1
9321 | 1 | 1
9333 | 1 | 1
9364 | 1 | 1
9366 | 1 | 1
9392 | 1 | 1
9406 | 1 | 1
9408 | 1 | 1
9439 | 1 | 1
9443 | 1 | 1
9444 | 1 | 1
9457 | 1 | 1
9479 | 1 | 1
Dec | 19 | 19
9571 | 1 | 1
9614 | 1 | 1
9666 | 1 | 1
9677 | 1 | 1
9746 | 1 | 1
9804 | 1 | 1
9937 | 1 | 1
9949 | 1 | 1
9959 | 1 | 1
10003 | 1 | 1
10010 | 1 | 1
10011 | 1 | 1
10027 | 1 | 1
10099 | 1 | 1
10151 | 1 | 1
10153 | 1 | 1
10155 | 1 | 1
10160 | 1 | 1
10528 | 1 | 1
2012
Jan | 39 | 38
10570 | 1 | 1
10599 | 1 | 1
10601 | 1 | 1
10635 | 1 | 1
10636 | 1 | 1
10661 | 1 | 1
10662 | 1 | 1
10688 | 1 | 1
10719 | 1 | 1
10731 | 1 | 1
10734 | 1 | 1
10749 | 1 | 1
10754 | 1 | 1
10756 | 1 | 1
10766 | 1 | 1
12328 | 1 | 1
12814 | 1 | 1
12837 | 1 | 1
12840 | 1 | 1
12860 | 1 | 1
12861 | 1
12921 | 1 | 1
12932 | 1 | 1
13513 | 1 | 1
13530 | 1 | 1
13554 | 1 | 1
13657 | 1 | 1
13724 | 1 | 1
13756 | 1 | 1
13772 | 1 | 1
13784 | 1 | 1
13785 | 1 | 1
13791 | 1 | 1
13801 | 1 | 1
13811 | 1 | 1
13813 | 1 | 1
13826 | 1 | 1
13827 | 1 | 1
13831 | 1 | 1
Feb | 24 | 21
13885 | 1
13925 | 1 | 1
13926 | 1 | 1
13968 | 1 | 1
14129 | 1 | 1
14156 | 1 | 1
14191 | 1 | 1
14196 | 1 | 1
14200 | 1 | 1
14226 | 1 | 1
14232 | 1 | 1
14243 | 1 | 1
14275 | 1
14283 | 1 | 1
14322 | 1
14402 | 1 | 1
14453 | 1 | 1
14455 | 1 | 1
14466 | 1 | 1
14508 | 1 | 1
14540 | 1 | 1
14606 | 1 | 1
14607 | 1 | 1
14654 | 1 | 1
Mar | 1
14680 | 1
Grand Total | 565 | 527