Below is the pivot table I want to filter based on a separate list containing deliverynotenumber.
Could anyone help as normally this column contains hundreds of deliverynotenumbers and i need to filter the pivot table for appx 20-22 numbers, which is very time consuming manually.
Thanks for helping everyone.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Could anyone help as normally this column contains hundreds of deliverynotenumbers and i need to filter the pivot table for appx 20-22 numbers, which is very time consuming manually.
Thanks for helping everyone.
| Sum of Qty Delivered | ||||
| Deliverynotenumber | ECP PO# | Supplier Part No | ECP Part No | Total |
| 62595166 | 701063 | 7136788200 | 628590770 | 5 |
| 701063 Total | 5 | |||
| 701112 | 7136788200 | 628590770 | 11 | |
| 701112 Total | 11 | |||
| 701374 | 6243211330 | 637746170 | 6 | |
| 701374 Total | 6 | |||
| 701429 | 6243211330 | 637746170 | 7 | |
| 6243225190 | 641723840 | 8 | ||
| 701429 Total | 15 | |||
| 701431 | 6243211330 | 637746170 | 7 | |
| 701431 Total | 7 | |||
| 701432 | 4140017100 | 644440140 | 13 | |
| 6243225190 | 641723840 | 8 | ||
| 701432 Total | 21 | |||
| 701448 | 6243211330 | 637746170 | 6 | |
| 7136263100 | 628850330 | 5 | ||
| 701448 Total | 11 | |||
| 701450 | 6243211330 | 637746170 | 6 | |
| 701450 Total | 6 | |||
| 701490 | 5110093100 | 136590030 | 48 | |
| 6243158100 | 641110850 | 62 | ||
| 6243211330 | 637746170 | 7 | ||
| 701490 Total | 117 | |||
| 701491 | 5110093100 | 136590030 | 48 | |
| 6193090000 | 641727370 | 13 | ||
| 6243158100 | 641110850 | 30 | ||
| 701491 Total | 91 | |||
| 701492 | 5110093100 | 136590030 | 48 | |
| 6243158100 | 641110850 | 31 | ||
| 6243211330 | 637746170 | 7 | ||
| 701492 Total | 86 | |||
| 701526 | 5330017100 | 326220380 | 226 | |
| 6203117330 | 637723280 | 8 | ||
| 6213042330 | 637723490 | 14 | ||
| 6233001000 | 641110670 | 4 | ||
| 6233082000 | 641442130 | 2 | ||
| 6233159340 | 637723330 | 5 | ||
| 6233401000 | 641442990 | 2 | ||
| 6243087330 | 637722110 | 28 | ||
| 6243087340 | 637729110 | 1 | ||
| 6243211330 | 637746170 | 6 | ||
| 6243247330 | 637221050 | 38 | ||
| 6243285000 | 641442810 | 12 | ||
| 6243342000 | 641442620 | 5 | ||
| 6243349090 | 641735630 | 7 | ||
| 6243397000 | 641442940 | 3 | ||
| 6243522000 | 641443050 | 3 | ||
| 6253038090 | 641747120 | 7 | ||
| 6263033330 | 637587530 | 10 | ||
| 7136787900 | 628660740 | 50 | ||
| 7136971000 | 628630140 | 4 | ||
| 701526 Total | 435 | |||
| 62595167 | 701610 | 5110093100 | 136590030 | 50 |
| 5300576100 | 348778658 | 3 | ||
| 6243211330 | 637746170 | 11 | ||
| 6243285000 | 641442810 | 7 | ||
| 6243397000 | 641442940 | 4 | ||
| 7136263100 | 628850330 | 12 | ||
| 7136971000 | 628630140 | 4 | ||
| 701610 Total | 91 | |||
| 701611 | 5330017100 | 326220380 | 173 | |
| 6213042330 | 637723490 | 5 | ||
| 6243087330 | 637722110 | 14 | ||
| 6243180090 | 641442030 | 23 | ||
| 6243285000 | 641442810 | 7 | ||
| 7136787900 | 628660740 | 68 | ||
| 701611 Total | 290 | |||
| 851707 | 6253106000 | 641692350 | 25 | |
| 851707 Total | 25 | |||
| 854652 | 7136263100 | 628850330 | 7 | |
| 7136788200 | 628590770 | 30 | ||
| 854652 Total | 37 | |||
| 855308 | 6243225190 | 641723840 | 3 | |
| 7136788200 | 628590770 | 24 | ||
| 855308 Total | 27 | |||
| 856544 | 6243225190 | 641723840 | 12 | |
| 856544 Total | 12 | |||
| 857156 | 6193090000 | 641727370 | 13 | |
| 857156 Total | 13 | |||
| 858695 | 6243346000 | 641110530 | 1 | |
| 858695 Total | 1 | |||
| 860203 | 6243180090 | 641442030 | 198 | |
| 860203 Total | 198 | |||
| 860625 | 6243158100 | 641110850 | 99 | |
| 6243180090 | 641442030 | 46 | ||
| 6243200340 | 637747150 | 3 | ||
| 6243211330 | 637746170 | 12 | ||
| 6243346000 | 641110530 | 1 | ||
| 7136263100 | 628850330 | 5 | ||
| 860625 Total | 166 | |||
| 860854 | 6243158100 | 641110850 | 60 | |
| 6243180090 | 641442030 | 23 | ||
| 7136263100 | 628850330 | 21 | ||
| 860854 Total | 104 | |||
| 861222 | 7136186700 | 628820340 | 4 | |
| 7136263100 | 628850330 | 7 | ||
| 861222 Total | 11 | |||
| 861946 | 5110093100 | 136590030 | 1 | |
| 5330017100 | 326220380 | 92 | ||
| 6243180090 | 641442030 | 22 | ||
| 7136494200 | 628110530 | 3 | ||
| 7136787900 | 628660740 | 51 | ||
| 861946 Total | 169 | |||
| 861947 | 6241313000 | 641590710 | 12 | |
| 6243211330 | 637746170 | 7 | ||
| 861947 Total | 19 | |||
| 862296 | 5340336100 | 326221300 | 4 | |
| 5350128100 | 425590090 | 23 | ||
| 6241313000 | 641590710 | 12 | ||
| 862296 Total | 39 | |||
| 862596 | 5300534100 | 348820228 | 7 | |
| 5320402300 | 326720360 | 7 | ||
| 5340336100 | 326221300 | 6 | ||
| 5340362100 | 326546390 | 1 | ||
| 6221190000 | 641590530 | 1 | ||
| 7136186700 | 628820340 | 4 | ||
| 862596 Total | 26 | |||
| 862956 | 4180395100 | 650590130 | 36 | |
| 4200010100 | 313330030 | 16 | ||
| 5000333200 | 644880020 | 15 | ||
| 5001065100 | 644440080 | 10 | ||
| 5100133100 | 645820120 | 12 | ||
| 5100225100 | 645740050 | 45 | ||
| 5110353100 | 136590070 | 90 | ||
| 5120045100 | 645580100 | 8 | ||
| 5300524100 | 348779728 | 1 | ||
| 5300537100 | 348690178 | 6 | ||
| 5300573100 | 348900018 | 6 | ||
| 5300576100 | 348778658 | 4 | ||
| 5300577100 | 348590088 | 5 | ||
| 5300578100 | 348540158 | 8 | ||
| 5300581100 | 348670028 | 9 | ||
| 5300582100 | 348778278 | 91 | ||
| 5300584100 | 348440758 | 6 | ||
| 5310030100 | 326545130 | 4 | ||
| 5320051100 | 328440061 | 8 | ||
| 5320144100 | 326110200 | 3 | ||
| 5320308100 | 326745240 | 5 | ||
| 5320402300 | 326720360 | 20 | ||
| 5320534100 | 326746380 | 21 | ||
| 5320556100 | 326111250 | 31 | ||
| 5330001100 | 326110140 | 2 | ||
| 5340039100 | 326110610 | 8 | ||
| 5340147100 | 326580770 | 18 | ||
| 5340180100 | 326546210 | 28 | ||
| 5340240100 | 326746440 | 52 | ||
| 5340278100 | 326442160 | 10 | ||
| 5350005100 | 425440020 | 63 | ||
| 5350036100 | 425440130 | 5 | ||
| 5350164100 | 425110040 | 4 | ||
| 5350174100 | 425830020 | 8 | ||
| 5350194100 | 425590150 | 6 | ||
| 5410146100 | 619220725 | 6 | ||
| 6180043060 | 641440020 | 6 | ||
| 6181693000 | 641540150 | 8 | ||
| 6181970000 | 641441230 | 4 | ||
| 6183086330 | 637740070 | 7 | ||
| 6190015060 | 641590780 | 3 | ||
| 6192395330 | 637722030 | 13 | ||
| 6193063330 | 637592380 | 156 | ||
| 6200278060 | 641440130 | 3 | ||
| 6200857000 | 641550070 | 3 | ||
| 6201284000 | 641440620 | 23 | ||
| 6203090340 | 637729430 | 17 | ||
| 6211646000 | 641660210 | 2 | ||
| 6212135000 | 641593680 | 2 | ||
| 6213012330 | 637721830 | 2 | ||
| 6213013330 | 637590930 | 2 | ||
| 6213027000 | 641720100 | 3 | ||
| 6213045090 | 641723740 | 26 | ||
| 6213050330 | 637723810 | 11 | ||
| 6220302060 | 641745050 | 4 | ||
| 6221190000 | 641590530 | 2 | ||
| 6222091000 | 641590590 | 5 | ||
| 6222317000 | 641721910 | 2 | ||
| 6222405330 | 637220570 | 10 | ||
| 6222414330 | 637592240 | 222 | ||
| 6222414340 | 637590570 | 6 | ||
| 6223095330 | 637723090 | 17 | ||
| 6223113330 | 637592940 | 3 | ||
| 6223128090 | 641592980 | 4 | ||
| 6223139090 | 641591030 | 12 | ||
| 6223146330 | 637727360 | 7 | ||
| 6223231090 | 641591080 | 8 | ||
| 6230608000 | 641721530 | 3 | ||
| 6230972000 | 641721600 | 5 | ||
| 6231139000 | 641441120 | 2 | ||
| 6231845000 | 641582160 | 17 | ||
| 6232102330 | 637721920 | 2 | ||
| 6232104330 | 637441240 | 14 | ||
| 6232291090 | 641746120 | 2 | ||
| 6233043000 | 641735230 | 58 | ||
| 6233083090 | 641745770 | 1 | ||
| 6233131330 | 637722210 | 4 | ||
| 6233148000 | 641830020 | 1 | ||
| 6233159340 | 637723330 | 6 | ||
| 6233210090 | 641723590 | 14 | ||
| 6233241000 | 641730040 | 3 | ||
| 6233292000 | 641442740 | 2 | ||
| 6233314090 | 641811550 | 3 | ||
| 6241489000 | 641582030 | 1 | ||
| 6242158000 | 641220550 | 2 | ||
| 6242231090 | 641660330 | 2 | ||
| 6242277000 | 641441280 | 2 | ||
| 6243033000 | 641442220 | 4 | ||
| 6243077330 | 637723200 | 8 | ||
| 6243116000 | 641441720 | 13 | ||
| 6243120090 | 641722080 | 1 | ||
| 6243126090 | 641441860 | 13 | ||
| 6243154330 | 637660030 | 20 | ||
| 6243156340 | 637442090 | 7 | ||
| 6243172000 | 641111050 | 3 | ||
| 6243219330 | 637746190 | 4 | ||
| 6243230340 | 637442070 | 5 | ||
| 6243260190 | 641660810 | 1 | ||
| 6243279090 | 641442390 | 10 | ||
| 6243285000 | 641442810 | 15 | ||
| 6243297330 | 637592840 | 53 | ||
| 6243309000 | 641592320 | 9 | ||
| 6243312090 | 641746370 | 128 | ||
| 6243312330 | 637749370 | 8 | ||
| 6243312340 | 637746370 | 5 | ||
| 6243330000 | 641442460 | 7 | ||
| 6243358330 | 637510350 | 7 | ||
| 6243376330 | 637510310 | 2 | ||
| 6243378330 | 637592550 | 5 | ||
| 6243434330 | 637720110 | 1 | ||
| 6243553090 | 641443120 | 12 | ||
| 6253070090 | 641822320 | 3 | ||
| 7136157100 | 628595240 | 10 | ||
| 7136203700 | 628670110 | 4 | ||
| 7136492800 | 628110300 | 23 | ||
| 7136493800 | 628110610 | 23 | ||
| 7136610200 | 628690760 | 3 | ||
| 7136671600 | 628110090 | 3 | ||
| 7136673300 | 628910000 | 13 | ||
| 7136673400 | 628910010 | 14 | ||
| 7136673500 | 628220150 | 4 | ||
| 7136680100 | 628220990 | 9 | ||
| 7136780600 | 628590150 | 5 | ||
| 7136784300 | 628590550 | 38 | ||
| 862956 Total | 1900 | |||
| 62595168 | 701556 | 5300135100 | 348771068 | 4 |
| 5300313100 | 348770908 | 12 | ||
| 5300542100 | 348779968 | 42 | ||
| 701556 Total | 58 | |||
| 62595174 | 701491 | 4150158100 | 336110980 | 4 |
| 4150273100 | 336850050 | 10 | ||
| 701491 Total | 14 | |||
| 701492 | 4150273100 | 336850050 | 17 | |
| 701492 Total | 17 | |||
| 701526 | 4150244100 | 336440660 | 21 | |
| 4150272100 | 336600120 | 71 | ||
| 4150273100 | 336850050 | 13 | ||
| 4150284100 | 336820230 | 11 | ||
| 4150300100 | 336850100 | 6 | ||
| 4150386100 | 336111220 | 8 | ||
| 4150485100 | 336740000 | 7 | ||
| 4150543100 | 336670020 | 31 | ||
| 701526 Total | 168 | |||
| Grand Total | 4196 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
