Spreadsheet: 33378d1229681973-pivot-table-calculation-pivot-table-query
Sheet: 03.11.08-09.11.08 Data

Plant | Delivery | Created by | Driver Name | Ship-to Party | Material number | Current Holding Quantity | Material Pricing Group | Material pricing group 1 | Delivered date | Reporting attribute | Actual quantity delivered | Promised Quantity | Amount Overordered
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 101-CD | 121 | M1 | T06 | 20081104 | MMR | 17 | 20 | 3
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 101-E | 145 | M1 |  | 20081104 | MMR | 12 | 12 | 0
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 101-G | 12 | M1 |  | 20081104 | MMR | 1 | 1 | 0
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 101-HX | 64 | M1 |  | 20081104 | MMR | 6 | 6 | 0
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 201-C | 38 | M1 |  | 20081104 | MMR | 8 | 8 | 0
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 211-CD | 10 | M1 |  | 20081104 | MMR | 2 | 2 | 0
1041 | 231094757 | SMYTHJ | S SHINKFIE1041 | 1098305 | 211-D | 16 | M1 |  | 20081104 | MMR | 2 | 2 | 0
1041 | 231083052 | SMYTHJ | S SHINKFIE1041 | 1098305 | 211-F | 10 | M1 |  | 20081101 | MMR | 5 | 5 | 0
1041 | 231125032 | WARINGA | NJ 041V | 1098305 | 211-G | 28 | M1 |  | 20081107 | MMR | 10 | 10 | 0
1041 | 231137352 | SMYTHJ | S SHINKFIE1041 | 1098314 | 101-HX | 12 | M1 |  | 20081108 | MMR | 1 | 1 | 0
1041 | 231083053 | SMYTHJ | S SHINKFIE1041 | 1098314 | 101-J | 44 | M1 |  | 20081101 | MMR | 24 | 24 | 0
1041 | 231094758 | SMYTHJ | S SHINKFIE1041 | 1098314 | 101-J | 44 | M1 |  | 20081104 | MMR | 20 | 20 | 0
1041 | 231137352 | SMYTHJ | S SHINKFIE1041 | 1098314 | 101-J | 44 | M1 |  | 20081108 | MMR | 24 | 24 | 0
1035 | 231106845 | BOULLTT | [NAME]1035 | 1190199 | 101-CD | 36 | M1 |  | 20081105 | SYN | 6 | 6 | 0
1035 | 231106845 | BOULLTT | [NAME]1035 | 1190199 | 101-E | 22 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1035 | 231106845 | BOULLTT | [NAME]1035 | 1190199 | 101-F | 42 | M1 |  | 20081105 | SYN | 6 | 6 | 0
1035 | 231106845 | BOULLTT | [NAME]1035 | 1190199 | 201-C | 6 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1035 | 231126893 | HILL1C | milkround1    1035 | 1190201 | 101-CD | 11 | M1 |  | 20081107 | SYN | 4 | 4 | 0
1035 | 231126893 | HILL1C | milkround1    1035 | 1190201 | 101-E | 19 | M1 |  | 20081107 | SYN | 2 | 2 | 0
1035 | 231094947 | GREENWJ | milkround1    1035 | 1190201 | 101-J | 53 | M1 |  | 20081104 | SYN | 8 | 8 | 0
1035 | 231126893 | HILL1C | milkround1    1035 | 1190201 | 101-J | 53 | M1 | T06 | 20081107 | SYN | 0 | 8 | 8
1035 | 231136311 | HILL1C | [NAME] | 1190203 | 101-J | 22 | M1 |  | 20081108 | SYN | 8 | 8 | 0
1028 | 231105086 | SMYTHJ | Route 1       1028 | 1298795 | 101-CD | 67 | M1 |  | 20081105 | MMR | 12 | 6 | -6
1028 | 231127125 | SMYTHJ | Route 1       1028 | 1298795 | 101-CD | 67 | M1 | T06 | 20081107 | MMR | 2 | 6 | 4
1028 | 231105086 | SMYTHJ | Route 1       1028 | 1298795 | 141-E | 15 | M1 |  | 20081105 | MMR | 2 | 2 | 0
1028 | 231105086 | SMYTHJ | Route 1       1028 | 1298795 | 201-C | 16 | M1 |  | 20081105 | MMR | 6 | 4 | -2
1028 | 231127125 | SMYTHJ | Route 1       1028 | 1298795 | 201-C | 16 | M1 | T06 | 20081107 | MMR | 0 | 3 | 3
1028 | 231084172 | SMYTHJ | Route 2       1028 | 1299074 | 101-CD | 24 | M1 | T06 | 20081103 | MMR | 1 | 4 | 3
1028 | 231116300 | SMYTHJ | Route 2       1028 | 1299074 | 101-CD | 24 | M1 |  | 20081106 | MMR | 6 | 6 | 0
1028 | 231084172 | SMYTHJ | Route 2       1028 | 1299074 | 101-J | 27 | M1 | T06 | 20081103 | MMR | 6 | 12 | 6
1028 | 231095012 | SMYTHJ | Route 2       1028 | 1299074 | 101-J | 27 | M1 | P02 | 20081104 | MMR | 10 | 12 | 2
1028 | 231107574 | WRAGGL | [NAME] | 1299074 | 101-J | 27 | M1 |  | 20081105 | MMR | 12 | 12 | 0
1023 | 231119442 | GREGORA | Combes        1023 | 1319319 | 101-J | 3 | M1 |  | 20081106 | SYN | 2 | 2 | 0
1051 | 231094748 | SMYTHJ | L MEEHAN  1051 | 1326245 | 101-CD | 39 | M1 |  | 20081104 | MMR | 1 | 1 | 0
1051 | 231126827 | SMYTHJ | L MEEHAN  1051 | 1326245 | 101-CD | 39 | M1 |  | 20081107 | MMR | 1 | 1 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-CD | 264 | M1 |  | 20081104 | MMR | 40 | 40 | 0
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-CD | 264 | M1 |  | 20081107 | MMR | 40 | 40 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-E | 243 | M1 |  | 20081104 | MMR | 20 | 18 | -2
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-E | 243 | M1 |  | 20081107 | MMR | 30 | 20 | -10
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-F | 16 | M1 |  | 20081107 | MMR | 1 | 1 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-G | 9 | M1 |  | 20081104 | MMR | 1 | 1 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-HX | 138 | M1 |  | 20081104 | MMR | 37 | 25 | -12
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 101-HX | 138 | M1 | P02 | 20081107 | MMR | 31 | 35 | 4
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 191-F | 4 | M1 | T06 | 20081104 | MMR | 1 | 2 | 1
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 201-C | 83 | M1 |  | 20081104 | MMR | 4 | 4 | 0
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 201-C | 83 | M1 |  | 20081107 | MMR | 6 | 6 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 201-E | 28 | M1 |  | 20081104 | MMR | 3 | 2 | -1
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 211-G | 58 | M1 |  | 20081104 | MMR | 12 | 12 | 0
1051 | 231126828 | SMYTHJ | L MEEHAN  1051 | 1326257 | 211-G | 58 | M1 |  | 20081107 | MMR | 8 | 8 | 0
1051 | 231094749 | SMYTHJ | L MEEHAN  1051 | 1326257 | 211-HX | 28 | M1 | T06 | 20081104 | MMR | 0 | 2 | 2
1051 | 231087198 | [NAME] | M GARNER  1051 | 1327406 | 101-E | 31 | M1 |  | 20081103 | MMR | 8 | 8 | 0
1060 | 231093815 | OKANED | OKANED 060V | 1329210 | 101-CD | 208 | M1 |  | 20081103 | SYN | 40 | 40 | 0
1060 | 231105113 | SMYTHJ | MARALN        1060 | 1329210 | 101-CD | 208 | M1 | C04 | 20081104 | SYN | 0 | 30 | 30
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 101-CD | 208 | M1 |  | 20081105 | SYN | 70 | 70 | 0
1060 | 231105113 | SMYTHJ | MARALN        1060 | 1329210 | 101-F | 59 | M1 | C04 | 20081104 | SYN | 0 | 1 | 1
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 101-F | 59 | M1 |  | 20081105 | SYN | 8 | 8 | 0
1060 | 231105113 | SMYTHJ | MARALN        1060 | 1329210 | 101-G | 12 | M1 | C04 | 20081104 | SYN | 0 | 1 | 1
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 101-G | 12 | M1 |  | 20081105 | SYN | 6 | 6 | 0
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 141-D |  | M1 |  | 20081105 | SYN | 2 | 2 | 0
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 191-E | 11 | M1 |  | 20081105 | SYN | 3 | 3 | 0
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 201-C | 6 | M1 | S13 | 20081105 | SYN | 0 | 4 | 4
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 211-CD | 15 | M1 |  | 20081105 | SYN | 4 | 4 | 0
1060 | 231105120 | SMYTHJ | MARALN        1060 | 1329210 | 211-F | 19 | M1 |  | 20081105 | SYN | 6 | 6 | 0
1060 | 231105112 | SMYTHJ | MARALN        1060 | 1329219 | 101-J | 43 | M1 | C04 | 20081104 | SYN | 0 | 6 | 6
1060 | 231105119 | SMYTHJ | MARALN        1060 | 1329219 | 101-J | 43 | M1 |  | 20081105 | SYN | 15 | 15 | 0
1051 | 231087231 | [NAME] | I ROUKE   1051 | 1332520 | 101-CD | 187 | M1 | T10 | 20081104 | MMR | 35 | 35 | 0
1051 | 231087231 | [NAME] | I ROUKE   1051 | 1332520 | 101-HX | 21 | M1 | T06 | 20081104 | MMR | 8 | 10 | 2
1051 | 231087231 | [NAME] | I ROUKE   1051 | 1332520 | 211-CD | 26 | M1 |  | 20081104 | MMR | 5 | 5 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 101-CD | 221 | M1 |  | 20081103 | SYN | 50 | 50 | 0
1051 | 231105517 | SMYTHJ | J UNSWORTH1051 | 1332536 | 101-CD | 221 | M1 |  | 20081105 | SYN | 35 | 35 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 101-E | 48 | M1 | T06 | 20081103 | SYN | 1 | 3 | 2
1051 | 231105517 | SMYTHJ | J UNSWORTH1051 | 1332536 | 101-E | 48 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 101-HX | 86 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 191-E | 37 | M1 |  | 20081103 | SYN | 3 | 3 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 201-C | 24 | M1 |  | 20081103 | SYN | 6 | 6 | 0
1051 | 231083071 | SMYTHJ | J UNSWORTH1051 | 1332536 | 211-CD | 90 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231105517 | SMYTHJ | J UNSWORTH1051 | 1332536 | 211-CD | 90 | M1 | P02 | 20081105 | SYN | 11 | 12 | 1
1051 | 231105517 | SMYTHJ | J UNSWORTH1051 | 1332536 | 211-HX | 36 | M1 |  | 20081105 | SYN | 4 | 4 | 0
1051 | 231083072 | SMYTHJ | J UNSWORTH1051 | 1332545 | 141-G | 31 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231083072 | SMYTHJ | J UNSWORTH1051 | 1332545 | 211-G | 31 | M1 |  | 20081103 | SYN | 10 | 10 | 0
1051 | 231105518 | SMYTHJ | J UNSWORTH1051 | 1332545 | 211-G | 31 | M1 |  | 20081105 | SYN | 12 | 12 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 101-E | 34 | M1 |  | 20081103 | SYN | 3 | 3 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 101-E | 34 | M1 |  | 20081105 | SYN | 3 | 3 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 191-E | 16 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 191-E | 16 | M1 |  | 20081105 | SYN | 3 | 3 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 191-G | 25 | M1 |  | 20081103 | SYN | 1 | 1 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 191-G | 25 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 201-C | 16 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 201-E | 22 | M1 |  | 20081105 | SYN | 3 | 3 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 211-CD | 23 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 211-G | 24 | M1 |  | 20081103 | SYN | 8 | 8 | 0
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 211-G | 24 | M1 |  | 20081105 | SYN | 4 | 4 | 0
1051 | 231083081 | SMYTHJ | L MEEHAN  1051 | 1332941 | 211-HX | 13 | M1 | P02 | 20081103 | SYN | 0 | 1 | 1
1051 | 231105525 | SMYTHJ | L MEEHAN  1051 | 1332941 | 211-HX | 13 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231083079 | SMYTHJ | L MEEHAN  1051 | 1332942 | 141-G | 20 | M1 |  | 20081103 | SYN | 6 | 6 | 0
1051 | 231105523 | SMYTHJ | L MEEHAN  1051 | 1332943 | 191-G | 8 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231083078 | SMYTHJ | L MEEHAN  1051 | 1332944 | 101-J | 11 | M1 |  | 20081103 | SYN | 3 | 3 | 0
1051 | 231083077 | SMYTHJ | L MEEHAN  1051 | 1332945 | 101-CD | 90 | M1 |  | 20081103 | SYN | 12 | 12 | 0
1051 | 231105522 | SMYTHJ | L MEEHAN  1051 | 1332945 | 101-CD | 90 | M1 |  | 20081105 | SYN | 7 | 7 | 0
1051 | 231083077 | SMYTHJ | L MEEHAN  1051 | 1332945 | 101-HX | 14 | M1 | P02 | 20081103 | SYN | 11 | 12 | 1
1051 | 231105522 | SMYTHJ | L MEEHAN  1051 | 1332945 | 101-HX | 14 | M1 |  | 20081105 | SYN | 8 | 8 | 0
1051 | 231083077 | SMYTHJ | L MEEHAN  1051 | 1332945 | 211-HX | 2 | M1 | P02 | 20081103 | SYN | 0 | 1 | 1
1051 | 231105522 | SMYTHJ | L MEEHAN  1051 | 1332945 | 211-HX | 2 | M1 |  | 20081105 | SYN | 1 | 1 | 0
1051 | 231083076 | SMYTHJ | L MEEHAN  1051 | 1332946 | 101-CD | 44 | M1 |  | 20081103 | SYN | 7 | 7 | 0
1051 | 231105521 | SMYTHJ | L MEEHAN  1051 | 1332946 | 101-CD | 44 | M1 |  | 20081105 | SYN | 7 | 7 | 0
1051 | 231083076 | SMYTHJ | L MEEHAN  1051 | 1332946 | 101-E | 19 | M1 |  | 20081103 | SYN | 2 | 2 | 0
1051 | 231083076 | SMYTHJ | L MEEHAN  1051 | 1332946 | 101-HX | 63 | M1 | T06 | 20081103 | SYN | 3 | 8 | 5
1051 | 231105521 | SMYTHJ | L MEEHAN  1051 | 1332946 | 101-HX | 63 | M1 |  | 20081105 | SYN | 4 | 4 | 0
1051 | 231105521 | SMYTHJ | L MEEHAN  1051 | 1332946 | 141-G | 14 | M1 |  | 20081105 | SYN | 2 | 2 | 0
1051 | 231083076 | SMYTHJ | L MEEHAN  1051 | 1332946 | 191-G | 9 | M1 |  | 20081103 | SYN | 4 | 4 | 0
1051 | 231083076 | SMYTHJ | L MEEHAN  1051 | 1332946 | 201-C | 20 | M1 |  | 20081103 | SYN | 3 | 3 | 0