Spreadsheet: 150974d1334750222-help-with-getting-data-from-two-pivots-into-a-table-gandyling
Sheet: Query Code Tables

 |  | 2011-08-01 00:00:00 |  | 2011-09-01 00:00:00 |  | 2011-10-01 00:00:00 |  | 2011-11-01 00:00:00 |  | 2011-12-01 00:00:00 |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  |  |  | Overall Total
 |  | Qty | % of total | Qty | % of total | Qty | % of total | Qty | % of total | Qty | % of total | Qty | % of total | Qty | % of total |  |  | Qty | % of total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
2 | 01.Input Error | 0 |  | 0 |  | 1 | 0.00819672131147541 | 1 | 0.008620689655172414 | 2 | 0.03076923076923077 | 1 | 0.006578947368421052 | 0 |  |  |  | 5 | 0.008064516129032258
3 | 02.Duplicated | 2 | 0.0625 | 3 | 0.0576923076923077 | 3 | 0.02459016393442623 | 8 | 0.06896551724137931 | 5 | 0.07692307692307693 | 8 | 0.05263157894736842 | 5 | 0.06172839506172839 |  |  | 34 | 0.05483870967741936
4 | 02a. Duplicated Sales | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1 | 0.01234567901234568 |  |  | 1 | 0.001612903225806452
5 | 02b. Duplicated Cust | 0 |  | 3 | 0.0576923076923077 | 0 |  | 0 |  | 2 | 0.03076923076923077 | 5 | 0.03289473684210526 | 1 | 0.01234567901234568 |  |  | 11 | 0.01774193548387097
6 | 03.Incomplete | 0 |  | 0 |  | 0 |  | 1 | 0.008620689655172414 | 0 |  | 1 | 0.006578947368421052 | 0 |  |  |  | 2 | 0.003225806451612903
7 | 04.Packing Error | 4 | 0.125 | 14 | 0.2692307692307692 | 1 | 0.00819672131147541 | 1 | 0.008620689655172414 | 1 | 0.01538461538461539 | 0 |  | 1 | 0.01234567901234568 |  |  | 22 | 0.03548387096774194
8 | 05.Picking Error | 0 |  | 1 | 0.01923076923076923 | 0 |  | 0 |  | 0 |  | 1 | 0.006578947368421052 | 0 |  |  |  | 2 | 0.003225806451612903
9 | 06.Manual Fault | 1 | 0.03125 | 1 | 0.01923076923076923 | 0 |  | 3 | 0.02586206896551724 | 1 | 0.01538461538461539 | 3 | 0.01973684210526316 | 0 |  |  |  | 9 | 0.01451612903225807
10 | 07.Damaged | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2 | 0.0131578947368421 | 0 |  |  |  | 2 | 0.003225806451612903
11 | 08.Driver Error | 0 |  | 0 |  | 0 |  | 0 |  | 1 | 0.01538461538461539 | 2 | 0.0131578947368421 | 1 | 0.01234567901234568 |  |  | 4 | 0.006451612903225806
12 | 09.Cancelled | 0 |  | 1 | 0.01923076923076923 | 0 |  | 1 | 0.008620689655172414 | 4 | 0.06153846153846154 | 5 | 0.03289473684210526 | 8 | 0.09876543209876543 |  |  | 19 | 0.03064516129032258
13 | 10.Returns RST | 0 |  | 2 | 0.03846153846153846 | 0 |  | 0 |  | 0 |  | 1 | 0.006578947368421052 | 4 | 0.04938271604938271 |  |  | 7 | 0.01129032258064516
14 | 10a.[NAME] | 0 |  | 0 |  | 0 |  | 16 | 0.1379310344827586 | 3 | 0.04615384615384616 | 3 | 0.01973684210526316 | 0 |  |  |  | 22 | 0.03548387096774194
15 | 11.Not required | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3 | 0.01973684210526316 | 0 |  |  |  | 3 | 0.004838709677419355
16 | 12.Recharge A/C | 2 | 0.0625 | 2 | 0.03846153846153846 | 0 |  | 3 | 0.02586206896551724 | 1 | 0.01538461538461539 | 6 | 0.03947368421052631 | 2 | 0.02469135802469136 |  |  | 16 | 0.02580645161290323
17 | 13.Quality | 1 | 0.03125 | 1 | 0.01923076923076923 | 0 |  | 0 |  | 1 | 0.01538461538461539 | 0 |  | 0 |  |  |  | 3 | 0.004838709677419355
18 | 14.Not on Van | 0 |  | 0 |  | 0 |  | 0 |  | 6 | 0.09230769230769231 | 1 | 0.006578947368421052 | 5 | 0.06172839506172839 |  |  | 12 | 0.01935483870967742
19 | 15.Credit Error | 0 |  | 0 |  | 0 |  | 0 |  | 1 | 0.01538461538461539 | 3 | 0.01973684210526316 | 2 | 0.02469135802469136 |  |  | 6 | 0.00967741935483871
20 | 16.Admin Error | 0 |  | 0 |  | 0 |  | 4 | 0.03448275862068965 | 3 | 0.04615384615384616 | 4 | 0.02631578947368421 | 0 |  |  |  | 11 | 0.01774193548387097
21 | 17. Back Office Error | 2 | 0.0625 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 2 | 0.003225806451612903
22 | 18.I/S Display | 0 |  | 1 | 0.01923076923076923 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 1 | 0.001612903225806452
23 | 19.Fitted Pans | 0 |  | 4 | 0.07692307692307693 | 0 |  | 2 | 0.01724137931034483 | 0 |  | 3 | 0.01973684210526316 | 5 | 0.06172839506172839 |  |  | 14 | 0.02258064516129032
24 | 20.Promotion | 1 | 0.03125 | 3 | 0.0576923076923077 | 4 | 0.03278688524590164 | 18 | 0.1551724137931035 | 5 | 0.07692307692307693 | 25 | 0.1644736842105263 | 6 | 0.07407407407407407 |  |  | 62 | 0.1
25 | 21.Good Will | 0 |  | 0 |  | 0 |  | 0 |  | 1 | 0.01538461538461539 | 0 |  | 4 | 0.04938271604938271 |  |  | 5 | 0.008064516129032258
26 | 22.Cred R/Stock | 11 | 0.34375 | 12 | 0.2307692307692308 | 106 | 0.8688524590163934 | 54 | 0.4655172413793103 | 16 | 0.2461538461538462 | 52 | 0.3421052631578947 | 13 | 0.1604938271604938 |  |  | 264 | 0.4258064516129032
27 | 23.ASM Discount | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2 | 0.02469135802469136 |  |  | 2 | 0.003225806451612903
28 | 24.Disp Support | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 0
29 | 25.Disp no Support | 0 |  | 0 |  | 0 |  | 0 |  | 1 | 0.01538461538461539 | 1 | 0.006578947368421052 | 5 | 0.06172839506172839 |  |  | 7 | 0.01129032258064516
30 | 26. Rebate | 5 | 0.15625 | 1 | 0.01923076923076923 | 3 | 0.02459016393442623 | 2 | 0.01724137931034483 | 6 | 0.09230769230769231 | 13 | 0.08552631578947369 | 8 | 0.09876543209876543 |  |  | 38 | 0.06129032258064516
31 | 27.Price Error | 3 | 0.09375 | 3 | 0.0576923076923077 | 4 | 0.03278688524590164 | 2 | 0.01724137931034483 | 5 | 0.07692307692307693 | 5 | 0.03289473684210526 | 4 | 0.04938271604938271 |  |  | 26 | 0.04193548387096774
32 | 27a.Price - Sales Supertrade | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4 | 0.02631578947368421 | 4 | 0.04938271604938271 |  |  | 8 | 0.01290322580645161
33 | 27b.Price - Sales Input Error | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 0
34 | 27c.Price - Sales Duplicated Sales | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 0
35 | 27d.Price - Sales Duplicated Cust | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 | 0
36 | 28. No POD
37 | 28a.No Pod Depot 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
38 | 28b.No Pod Depot 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
39 | 28c.No Pod Depot 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
40 | 28d.No Pod Depot 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
41 | 29.Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
42 | 30.Not Delivered |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
43 | 31.No Credit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
44 | Total | 32 | 1 | 52 | 1 | 122 | 1 | 116 | 1 | 65 | 1 | 152 | 0.9999999999999999 | 81 | 1 | 0 |  | 620 | 1