dear,
i have below data sheet, i made a pivot table to show the average volume of each container type by dstn (destination).
But the answer is not correct.
pls help
i have below data sheet, i made a pivot table to show the average volume of each container type by dstn (destination).
But the answer is not correct.
pls help
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | containernbr | containertype | model | D20 | D40 | HC | Volume | Fdstn | ||
2 | A1 | D20 | X1 | 1 | 12 | BCN | ||||
3 | A1 | D20 | X2 | 6 | BCN | |||||
4 | A2 | D20 | X1 | 1 | 26 | BCN | ||||
5 | A3 | D20 | X1 | 1 | 15 | BCN | ||||
6 | A4 | D40 | X1 | 1 | 45 | BCN | ||||
7 | A4 | D40 | X2 | 12 | BCN | |||||
8 | A5 | D40 | X2 | 1 | 43 | BCN | ||||
9 | A6 | HC | X2 | 1 | 55 | RTM | ||||
10 | A6 | HC | X1 | 1 | 8 | RTM | ||||
11 | A7 | HC | X1 | 1 | 70 | RTM | ||||
12 | A8 | D20 | X1 | 1 | 45 | RTM | ||||
13 | A8 | D20 | X1 | 2 | RTM | |||||
14 | ||||||||||
15 | AverageofVolume | Fdstn | ||||||||
16 | containertype | BCN | RTM | Total | ||||||
17 | D20 | 14.75 | 23.50 | 17.67 | ||||||
18 | D40 | 33.33 | 33.33 | |||||||
19 | HC | 44.33 | 44.33 | |||||||
20 | Total | 22.71 | 36.00 | 28.25 | ||||||
21 | ||||||||||
22 | 14.75iswrong | |||||||||
23 | AverageforBCND20shouldbe(12+6+26+15)/3=19.66 | |||||||||
Sheet1 |