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

Ship-to Party | Material number | Data | Total
1098305 | 101-CD | Average of Current Holding Quantity | 121
 |  | Sum of Actual quantity delivered | 17
 | 101-E | Average of Current Holding Quantity | 145
 |  | Sum of Actual quantity delivered | 12
 | 101-G | Average of Current Holding Quantity | 12
 |  | Sum of Actual quantity delivered | 1
 | 101-HX | Average of Current Holding Quantity | 64
 |  | Sum of Actual quantity delivered | 6
 | 201-C | Average of Current Holding Quantity | 38
 |  | Sum of Actual quantity delivered | 8
 | 211-CD | Average of Current Holding Quantity | 10
 |  | Sum of Actual quantity delivered | 2
 | 211-D | Average of Current Holding Quantity | 16
 |  | Sum of Actual quantity delivered | 2
 | 211-F | Average of Current Holding Quantity | 10
 |  | Sum of Actual quantity delivered | 5
 | 211-G | Average of Current Holding Quantity | 28
 |  | Sum of Actual quantity delivered | 10
1098305 Sum of Current Holding Quantity |  |  | 444 | I want this number to the the sum of the averages in cells
1098305 Sum of Actual quantity delivered |  |  | 63 | D4,D6,D8,D10,D12,D14,D16,D18,D20 - and so on for each Ship-toParty.
1098314 | 101-HX | Average of Current Holding Quantity | 12
 |  | Sum of Actual quantity delivered | 1
 | 101-J | Average of Current Holding Quantity | 44
 |  | Sum of Actual quantity delivered | 68
1098314 Sum of Current Holding Quantity |  |  | 144
1098314 Sum of Actual quantity delivered |  |  | 69
1190199 | 101-CD | Average of Current Holding Quantity | 36
 |  | Sum of Actual quantity delivered | 6
 | 101-E | Average of Current Holding Quantity | 22
 |  | Sum of Actual quantity delivered | 1
 | 101-F | Average of Current Holding Quantity | 42
 |  | Sum of Actual quantity delivered | 6
 | 201-C | Average of Current Holding Quantity | 6
 |  | Sum of Actual quantity delivered | 1
1190199 Sum of Current Holding Quantity |  |  | 106
1190199 Sum of Actual quantity delivered |  |  | 14
1190201 | 101-CD | Average of Current Holding Quantity | 11
 |  | Sum of Actual quantity delivered | 4
 | 101-E | Average of Current Holding Quantity | 19
 |  | Sum of Actual quantity delivered | 2
 | 101-J | Average of Current Holding Quantity | 53
 |  | Sum of Actual quantity delivered | 8
1190201 Sum of Current Holding Quantity |  |  | 136
1190201 Sum of Actual quantity delivered |  |  | 14
1190203 | 101-J | Average of Current Holding Quantity | 22
 |  | Sum of Actual quantity delivered | 8
1190203 Sum of Current Holding Quantity |  |  | 22
1190203 Sum of Actual quantity delivered |  |  | 8
1298795 | 101-CD | Average of Current Holding Quantity | 67
 |  | Sum of Actual quantity delivered | 14
 | 141-E | Average of Current Holding Quantity | 15
 |  | Sum of Actual quantity delivered | 2
 | 201-C | Average of Current Holding Quantity | 16
 |  | Sum of Actual quantity delivered | 6
1298795 Sum of Current Holding Quantity |  |  | 181
1298795 Sum of Actual quantity delivered |  |  | 22
1299074 | 101-CD | Average of Current Holding Quantity | 24
 |  | Sum of Actual quantity delivered | 7
 | 101-J | Average of Current Holding Quantity | 27
 |  | Sum of Actual quantity delivered | 28
1299074 Sum of Current Holding Quantity |  |  | 129
1299074 Sum of Actual quantity delivered |  |  | 35
1319319 | 101-J | Average of Current Holding Quantity | 3
 |  | Sum of Actual quantity delivered | 2
1319319 Sum of Current Holding Quantity |  |  | 3
1319319 Sum of Actual quantity delivered |  |  | 2
1326245 | 101-CD | Average of Current Holding Quantity | 39
 |  | Sum of Actual quantity delivered | 2
1326245 Sum of Current Holding Quantity |  |  | 78
1326245 Sum of Actual quantity delivered |  |  | 2
1326257 | 101-CD | Average of Current Holding Quantity | 264
 |  | Sum of Actual quantity delivered | 80
 | 101-E | Average of Current Holding Quantity | 243
 |  | Sum of Actual quantity delivered | 50
 | 101-F | Average of Current Holding Quantity | 16
 |  | Sum of Actual quantity delivered | 1
 | 101-G | Average of Current Holding Quantity | 9
 |  | Sum of Actual quantity delivered | 1
 | 101-HX | Average of Current Holding Quantity | 138
 |  | Sum of Actual quantity delivered | 68
 | 191-F | Average of Current Holding Quantity | 4
 |  | Sum of Actual quantity delivered | 1
 | 201-C | Average of Current Holding Quantity | 83
 |  | Sum of Actual quantity delivered | 10
 | 201-E | Average of Current Holding Quantity | 28
 |  | Sum of Actual quantity delivered | 3
 | 211-G | Average of Current Holding Quantity | 58
 |  | Sum of Actual quantity delivered | 20
 | 211-HX | Average of Current Holding Quantity | 28
 |  | Sum of Actual quantity delivered | 0
1326257 Sum of Current Holding Quantity |  |  | 1657
1326257 Sum of Actual quantity delivered |  |  | 234
1327406 | 101-E | Average of Current Holding Quantity | 31
 |  | Sum of Actual quantity delivered | 8
1327406 Sum of Current Holding Quantity |  |  | 31
1327406 Sum of Actual quantity delivered |  |  | 8
1329210 | 101-CD | Average of Current Holding Quantity | 208
 |  | Sum of Actual quantity delivered | 110
 | 101-F | Average of Current Holding Quantity | 59
 |  | Sum of Actual quantity delivered | 8
 | 101-G | Average of Current Holding Quantity | 12
 |  | Sum of Actual quantity delivered | 6
 | 141-D | Average of Current Holding Quantity
 |  | Sum of Actual quantity delivered | 2
 | 191-E | Average of Current Holding Quantity | 11
 |  | Sum of Actual quantity delivered | 3
 | 201-C | Average of Current Holding Quantity | 6
 |  | Sum of Actual quantity delivered | 0
 | 211-CD | Average of Current Holding Quantity | 15
 |  | Sum of Actual quantity delivered | 4
 | 211-F | Average of Current Holding Quantity | 19
 |  | Sum of Actual quantity delivered | 6
1329210 Sum of Current Holding Quantity |  |  | 817
1329210 Sum of Actual quantity delivered |  |  | 139
1329219 | 101-J | Average of Current Holding Quantity | 43
 |  | Sum of Actual quantity delivered | 15
1329219 Sum of Current Holding Quantity |  |  | 86
1329219 Sum of Actual quantity delivered |  |  | 15
1332520 | 101-CD | Average of Current Holding Quantity | 187
 |  | Sum of Actual quantity delivered | 35
 | 101-HX | Average of Current Holding Quantity | 21
 |  | Sum of Actual quantity delivered | 8
 | 211-CD | Average of Current Holding Quantity | 26
 |  | Sum of Actual quantity delivered | 5
1332520 Sum of Current Holding Quantity |  |  | 234
1332520 Sum of Actual quantity delivered |  |  | 48
1332536 | 101-CD | Average of Current Holding Quantity | 221
 |  | Sum of Actual quantity delivered | 85
 | 101-E | Average of Current Holding Quantity | 48
 |  | Sum of Actual quantity delivered | 2
 | 101-HX | Average of Current Holding Quantity | 86
 |  | Sum of Actual quantity delivered | 2
 | 191-E | Average of Current Holding Quantity | 37
 |  | Sum of Actual quantity delivered | 3
 | 201-C | Average of Current Holding Quantity | 24
 |  | Sum of Actual quantity delivered | 6
 | 211-CD | Average of Current Holding Quantity | 90
 |  | Sum of Actual quantity delivered | 13
 | 211-HX | Average of Current Holding Quantity | 36
 |  | Sum of Actual quantity delivered | 4
1332536 Sum of Current Holding Quantity |  |  | 901
1332536 Sum of Actual quantity delivered |  |  | 115
1332545 | 141-G | Average of Current Holding Quantity | 31
 |  | Sum of Actual quantity delivered | 2
 | 211-G | Average of Current Holding Quantity | 31
 |  | Sum of Actual quantity delivered | 22
1332545 Sum of Current Holding Quantity |  |  | 93
1332545 Sum of Actual quantity delivered |  |  | 24
1332941 | 101-E | Average of Current Holding Quantity | 34
 |  | Sum of Actual quantity delivered | 6
 | 191-E | Average of Current Holding Quantity | 16
 |  | Sum of Actual quantity delivered | 5
 | 191-G | Average of Current Holding Quantity | 25
 |  | Sum of Actual quantity delivered | 2
 | 201-C | Average of Current Holding Quantity | 16
 |  | Sum of Actual quantity delivered | 1
 | 201-E | Average of Current Holding Quantity | 22
 |  | Sum of Actual quantity delivered | 3
 | 211-CD | Average of Current Holding Quantity | 23
 |  | Sum of Actual quantity delivered | 2
 | 211-G | Average of Current Holding Quantity | 24
 |  | Sum of Actual quantity delivered | 12
 | 211-HX | Average of Current Holding Quantity | 13
 |  | Sum of Actual quantity delivered | 1
1332941 Sum of Current Holding Quantity |  |  | 285
1332941 Sum of Actual quantity delivered |  |  | 32
1332942 | 141-G | Average of Current Holding Quantity | 20
 |  | Sum of Actual quantity delivered | 6
1332942 Sum of Current Holding Quantity |  |  | 20
1332942 Sum of Actual quantity delivered |  |  | 6
1332943 | 191-G | Average of Current Holding Quantity | 8
 |  | Sum of Actual quantity delivered | 1
1332943 Sum of Current Holding Quantity |  |  | 8
1332943 Sum of Actual quantity delivered |  |  | 1
1332944 | 101-J | Average of Current Holding Quantity | 11
 |  | Sum of Actual quantity delivered | 3
1332944 Sum of Current Holding Quantity |  |  | 11
1332944 Sum of Actual quantity delivered |  |  | 3
1332945 | 101-CD | Average of Current Holding Quantity | 90
 |  | Sum of Actual quantity delivered | 19
 | 101-HX | Average of Current Holding Quantity | 14
 |  | Sum of Actual quantity delivered | 19
 | 211-HX | Average of Current Holding Quantity | 2
 |  | Sum of Actual quantity delivered | 1
1332945 Sum of Current Holding Quantity |  |  | 212
1332945 Sum of Actual quantity delivered |  |  | 39
1332946 | 101-CD | Average of Current Holding Quantity | 44
 |  | Sum of Actual quantity delivered | 14
 | 101-E | Average of Current Holding Quantity | 19
 |  | Sum of Actual quantity delivered | 2
 | 101-HX | Average of Current Holding Quantity | 63
 |  | Sum of Actual quantity delivered | 7
 | 141-G | Average of Current Holding Quantity | 14
 |  | Sum of Actual quantity delivered | 2
 | 191-G | Average of Current Holding Quantity | 9
 |  | Sum of Actual quantity delivered | 4
 | 201-C | Average of Current Holding Quantity | 20
 |  | Sum of Actual quantity delivered | 3
1332946 Sum of Current Holding Quantity |  |  | 276
1332946 Sum of Actual quantity delivered |  |  | 32
Total Average of Current Holding Quantity |  |  | 53.4
Total Sum of Actual quantity delivered |  |  | 925