Spreadsheet: 109194d1306133105-excel-2007-double-filter-problem-in-pivot-table-excel-2007-pivot-filter-issue
Sheet: Pivot

Plant | (Multiple Items)
Type | (All)
Quality | (All)
Customer CODE | (All)
Sum of QTY
Item Code | Total
15301.0000100198 | 17.5638
15301.0000200194 | 20.17224
15301.0000400154 | 16.51494
15301.0000500195 | 0.7797600000000001
15301.0000600196 | 17.2887
15301.0000700227 | 7.88724
15301.0001400549 | 194.64858
15301.0001500525 | 145.15776
15301.0003900184 | 3.078
15301.0004100182 | 0.1035
15301.0006600185 | 38.124
15301.0009000152 | 9.066419999999999
15301.0009100111 | 8.27676
15301.0010800167 | 14.9625
15301.0010900121 | 10.242
15301.0013500054 | 31.098
15301.0013600099 | 152.05005
15301.0013700099 | 41.4711
15301.0014600005 | 23.208
15301.002070024 | 5.868
15301.0020800244 | 6.48
15301.0021200262 | 49.16195999999999
15301.0021500279 | 31.8318
15301.0021800028 | 93.2229
15301.0021900201 | 16.912746
15301.0022000209 | 17.047965
15301.0022700014 | 1.210275
15301.0027700063 | 10.665
15301.0028800079 | 25.2054
15301.0034000222 | 10.362
15301.0034200458 | 21.8124
15301.0034900029 | 31.95
15301.0035000482 | 8.38368
15301.0035100482 | 4.583760000000001
15301.0035200046 | 117.40032
15301.0035400046 | 14.52024
15301.0035700065 | 4.89
15301.0035900463 | 5.828939999999999
15301.0036000555 | 38.07048
15301.003610021 | 9.81432
15301.0036400034 | 17.038125
15301.0036600078 | 5.89245
15301.0037000216 | 7.63434
15301.0037200013 | 24.6615
15301.0037400024 | 4.3935
15301.0037600047 | 10.8984
15301.0037900128 | 8.55
15301.0038700016 | 11.52
15301.0038800038 | 152.25
15301.0039000143 | 5.643
15301.0043000312 | 374.9927999999999
15301.004350024 | 5.3592
15301.0043800011 | 69.7602
15301.0044000319 | 2.205
15301.0044900325 | 8.046
15301.0045500328 | 55.3707
15301.0046900003 | 21.03975
15301.0047900483 | 17.4828
15301.0048100458 | 170.5352999999999
15301.0048300469 | 10.41012
15301.0048400464 | 22.93368
15301.0048700315 | 2.81952
15301.0049300059 | 2.7825
15301.0049400339 | 0.20112
15301.0049600341 | 17.6874
15301.0049700198 | 8.39382
15301.0049800342 | 10.03938
15301.0050100326 | 1.01952
15301.0050400326 | 1.416
15301.0051000326 | 1.416
15301.0051400326 | 1.485
15301.0054600379 | 4.0446
15301.0055400557 | 35.6976
15301.0055500135 | 18.2103
15301.0055600354 | 13.43775
15301.0055700387 | 5.336175
15301.0056900038 | 10.5
15301.0057600123 | 2.97
15301.0059000434 | 6.3264
15301.0059100433 | 2.76012
15301.0059200436 | 5.078399999999999
15301.0060500446 | 19.20312
15301.0060600447 | 4.5144
15301.0060700448 | 38.01048000000001
15301.0061500456 | 29.94264
15301.0062200182 | 180.32292
15301.006230017 | 104.517
15301.0062400182 | 7.1373
15301.006250017 | 11.77416
15301.0062600182 | 14.2746
15301.0062800179 | 37.84833
15301.0063800374 | 3.56553
15301.0065000215 | 10.803
15301.0065200463 | 5.929200000000001
15301.0065400471 | 42.888
15301.0065700474 | 3.70944
15301.0065800475 | 2.50488
15301.0065900476 | 11.58822
15301.0066000477 | 4.852980000000001
15301.0066400479 | 24.12
15301.0066500479 | 23.97528
15301.006660048 | 27.1092
15301.0066700458 | 19.1187
15301.0066800458 | 20.7393
15301.0067200546 | 55.8981
15301.0067400487 | 20.4
15301.0067500471 | 115.52955
15301.0067600215 | 24.6675
15301.0067900191 | 6.462
15301.0068200321 | 20.09502
15301.0069600567 | 5.688
15301.007060051 | 29.1357
15301.0070700345 | 6.39144
15301.0072300527 | 7.144200000000001
15301.0073500535 | 3.51648
15301.0073600536 | 10.2453
15301.007550055 | 22.90662
15301.0075600551 | 17.4048
15301.0075700482 | 8.75856
15301.0076000464 | 54.4872
15301.0076100469 | 14.81004
15301.007710056 | 2.111688
15301.0077200561 | 24.96258
15301.0077400563 | 14.57712
15301.0077500483 | 26.01
15301.0077600458 | 24.7908
15301.0077700564 | 10.72224
15301.0077800565 | 2.99205
15301.0077900215 | 8.814
15301.0078000222 | 49.90464000000001
15301.0078400572 | 45.14748
15301.0078500527 | 3.675
15301.0078600573 | 6.99
15302.0004300299 | 20.21094
15302.0004400297 | 19.50594
15302.0005200269 | 95.92199999999997
15302.0005300276 | 32.104215
15302.0005500252 | 78.90813000000001
15302.0005600252 | 11.73816
15302.0011300305 | 23.97714
15302.0011400308 | 7.368555
15302.0011600249 | 73.005288
15302.001170025 | 62.62854000000001
15302.0011900255 | 76.16189999999999
15302.0012100285 | 6.905654999999999
15302.0012200241 | 20.5929
15302.0012400289 | 0.34836
15302.0012500286 | 0.69795
15302.0012700302 | 1.280985
15302.0030500247 | 5.304789
15302.0030700245 | 4.740588
15302.0031000421 | 9.006029999999999
15302.0031100424 | 10.269156
15302.0031300422 | 6.27285
15302.0031400423 | 17.301405
15302.003190042 | 27.694875
15302.0032100418 | 35.16480000000001
15302.0032300419 | 34.16562
15302.0048600402 | 9.9603
15302.0048800401 | 8.734155000000001
15302.0049000403 | 30.4317
15302.005470038 | 16.933608
15302.0054800443 | 16.9218
15302.0054900444 | 16.35774
15302.0055000441 | 9.463350000000002
15302.0055100442 | 10.92372
15302.0055200396 | 22.05144
15302.0072400528 | 5.9895
15302.0075000528 | 17.237781
15302.0075200276 | 6.989589
15302.0075800254 | 100.17366
15302.0076500308 | 4.753125000000001
15302.0076600256 | 8.7516
15302.0076700291 | 5.49441
15302.0076900305 | 3.528798
15302.0077000307 | 4.93812
15302.0078100568 | 4.7595
15302.0078200569 | 4.26
15302.0078300571 | 9.19275
15304.0002000296 | 5.103
15304.0002100275 | 2.31525
15304.0020900303 | 9.598575
15304.0029400532 | 24.133725
15304.0029500566 | 27.862575
15304.0029700489 | 22.04475
15304.002990057 | 7.337775000000001
15304.0030000335 | 43.67700000000001
15304.0030200336 | 23.48865
15304.0033100417 | 5.910299999999999
15304.0055300386 | 3.945
15304.0056400405 | 5.601975
15304.0065300122 | 84.65100000000001
15304.0069700503 | 4.98
15304.0072200188 | 24.31425
15306.0074200542 | 9.6894
15306.0078700574 | 9.957
Grand Total | 5041.574435999998