Spreadsheet: 151014d1334759625-help-with-getting-data-from-two-pivots-into-a-table-gandyling_pt_jpr73
Sheet: PT

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