ich möchte in meiner Pivot Tabelle eine Sortierung vornehmen und weiß nciht wie ich es lösen soll.
Ich möchte eine Sortierung haben, in der für alle Materialnummer nur ein Verfahren ausgegeben wird, das Problem : nicht für jede Materialnummer gibt es alle Verfahren.
Pivot Tabelle:
Tabelle1
L | M | N | O | P | Q | R | S | T | U | |
7 | Materialnummer | (Alle) | ||||||||
8 | ||||||||||
9 | Summe von Stueckzahl | Verfahren | ||||||||
10 | Jahr | Losperiode | DY | EX | GR | HA | SP | WI | Ist | Gesamtergebnis |
11 | 2007 | 0 | -80183 | -150827 | -80183 | -82293 | -80183 | -84257 | -557926 | |
12 | 1 | 4012208 | 1209300 | 2118253 | 2446020 | 2893888 | 3000285 | 15679954 | ||
13 | 2 | 1164484 | 300074 | 603429 | 745987 | 895859 | 184141 | 3893974 | ||
14 | 3 | 819107 | 273244 | 402538 | 446903 | 533089 | 484110 | 2958991 | ||
15 | 4 | 358976 | 337011 | 300281 | 312398 | 321033 | 265620 | 1895319 | ||
16 | 5 | 339716 | 376700 | 176269 | 294858 | 250526 | 431738 | 1869807 | ||
17 | 6 | 233649 | 359300 | 231906 | 254691 | 225629 | 327008 | 1632183 | ||
18 | 7 | 138761 | 363360 | 193251 | 275718 | 131121 | 272223 | 1374434 | ||
19 | 8 | 129239 | 246396 | 153352 | 140462 | 229820 | 261207 | 1160476 | ||
20 | 9 | 153255 | 292664 | 248053 | 179128 | 250715 | 259097 | 1382912 | ||
21 | 10 | 241138 | 449368 | 493280 | 422094 | 352600 | 287223 | 2245703 | ||
22 | 11 | 87749 | 392724 | 313782 | 353985 | 311399 | 486885 | 1946524 | ||
23 | 12 | 58316 | 224871 | 221972 | 128632 | 95074 | 98136 | 827001 | ||
24 | 2008 | 0 | -35190 | -119619 | -40137 | -40686 | -36258 | -62802 | -334692 | |
25 | 1 | 134232 | 337883 | 381565 | 251324 | 207425 | 361009 | 1673438 | ||
26 | 2 | 165168 | 365956 | 339961 | 311648 | 364802 | 218074 | 1765609 | ||
27 | 3 | 151392 | 296422 | 261052 | 237959 | 191545 | 154684 | 1293054 | ||
28 | 4 | 177962 | 358109 | 317863 | 257848 | 293443 | 261397 | 100 | 1666722 | |
29 | 5 | 166192 | 420502 | 425292 | 454736 | 260195 | 324782 | 2051699 | ||
30 | 6 | 193696 | 446201 | 405206 | 408728 | 284390 | 241731 | 1979952 | ||
31 | 7 | 138301 | 367214 | 227070 | 208599 | 214162 | 187983 | 1343329 | ||
32 | 8 | 151839 | 266293 | 277979 | 189756 | 135127 | 221638 | 300 | 1242932 | |
33 | 9 | 65660 | 236793 | 220517 | 140174 | 189047 | 236669 | 1088860 | ||
34 | 10 | 154900 | 320428 | 186659 | 235578 | 290037 | 171326 | 1358928 | ||
35 | 11 | 181407 | 302909 | 244043 | 286956 | 206842 | 270771 | 1492928 | ||
36 | 12 | 61764 | 165468 | 76194 | 105027 | 81451 | 59935 | 549839 | ||
37 | 2009 | 0 | -18397 | -147053 | -55091 | -50426 | -43401 | -106248 | -420616 | |
38 | 1 | 41562 | 183966 | 138963 | 131826 | 56300 | 157238 | 709855 | ||
39 | 2 | 21893 | 143541 | 76899 | 58316 | 92135 | 101037 | 493821 | ||
40 | 3 | 69063 | 133294 | 166004 | 110950 | 84035 | 97598 | 660944 | ||
41 | 4 | 8215 | 137749 | 68722 | 92696 | 67984 | 78479 | 453845 | ||
42 | 5 | 3406 | 76284 | 49723 | 38931 | 32521 | 59969 | 200 | 261034 | |
43 | 6 | 15750 | 85840 | 62120 | 45138 | 29160 | 72987 | 310995 | ||
44 | 7 | 20810 | 131118 | 123263 | 98830 | 68876 | 123654 | 566551 | ||
45 | 8 | 16025 | 98693 | 78522 | 33365 | 40644 | 31120 | 298369 | ||
46 | 9 | 54600 | 103744 | 96974 | 37081 | 52600 | 62345 | 407344 | ||
47 | 10 | 44830 | 154330 | 121395 | 73834 | 89601 | 76900 | 560890 | ||
48 | 11 | 57883 | 144028 | 72437 | 56740 | 36145 | 17586 | 384819 | ||
49 | 12 | 500 | 15600 | 500 | 6367 | 500 | 7000 | 30467 | ||
50 | Gesamtergebnis | 9699878 | 9699878 | 9699878 | 9699878 | 9699878 | 9700278 | 600 | 58200268 |
Tabellendarstellung in Foren Version 5.5
Privot Tabelle aus folgenden Daten:
Tabelle1
A | B | C | D | E | F | |
1 | Materialnummer | Verfahren | Jahr | Losperiode | Stueckzahl | Kosten |
2 | 1120003281 | DY | 2008 | 4 | 600 | 112,17286 |
3 | 1120003281 | EX | 2009 | 0 | -400 | 0 |
4 | 1120003281 | EX | 2007 | 1 | 500 | 114,217 |
5 | 1120003281 | EX | 2009 | 5 | 500 | 111,84316 |
6 | 1120003281 | GR | 2008 | 4 | 600 | 112,17286 |
7 | 1120003281 | HA | 2008 | 4 | 600 | 112,17286 |
8 | 1120003281 | SP | 2008 | 4 | 600 | 112,17286 |
9 | 1120003281 | WI | 2009 | 0 | 0 | |
10 | 1120003281 | WI | 2008 | 4 | 500 | 111,74425 |
11 | 1120003281 | WI | 2009 | 5 | 500 | 111,84316 |
12 | 1120003281 | Ist | 2008 | 4 | 100 | |
13 | 1120003281 | Ist | 2008 | 8 | 300 | |
14 | 1120003281 | Ist | 2009 | 5 | 200 | |
15 | 1120003285 | DY | 2007 | 0 | -499 | 0 |
16 | 1120003285 | DY | 2007 | 6 | 500 | 115,918483 |
17 | 1120003285 | EX | 2007 | 0 | -499 | 0 |
18 | 1120003285 | EX | 2007 | 1 | 500 | 116,753233 |
19 | 1120003285 | GR | 2007 | 0 | -499 | 0 |
20 | 1120003285 | GR | 2007 | 6 | 500 | 115,918483 |
21 | 1120003285 | HA | 2007 | 0 | -499 | 0 |
22 | 1120003285 | HA | 2007 | 6 | 500 | 115,918483 |
23 | 1120003285 | SP | 2007 | 0 | -499 | 0 |
24 | 1120003285 | SP | 2007 | 6 | 500 | 115,918483 |
25 | 1120003285 | WI | 2007 | 0 | -499 | 0 |
26 | 1120003285 | WI | 2007 | 6 | 500 | 115,918483 |
27 | 1120003286 | Ist | 2007 | 6 | 1 | |
28 | 1120003289 | DY | 2008 | 0 | -488 | 0 |
29 | 1120003289 | DY | 2008 | 3 | 500 | 115,385796 |
30 | 1120003289 | EX | 2007 | 0 | -488 | 0 |
31 | 1120003289 | EX | 2007 | 1 | 500 | 118,416096 |
32 | 1120003289 | GR | 2008 | 0 | -488 | 0 |
33 | 1120003289 | GR | 2008 | 3 | 500 | 115,385796 |
34 | 1120003289 | HA | 2008 | 0 | -488 | 0 |
35 | 1120003289 | HA | 2008 | 3 | 500 | 115,385796 |
36 | 1120003289 | SP | 2008 | 0 | -488 | 0 |
37 | 1120003289 | SP | 2008 | 3 | 500 | 115,385796 |
38 | 1120003289 | WI | 2008 | 0 | -488 | 0 |
39 | 1120003289 | WI | 2008 | 3 | 500 | 115,385796 |
40 | 1120003293 | DY | 2007 | 0 | -375 | 0 |
41 | 1120003293 | DY | 2007 | 5 | 500 | 116,088288 |
42 | 1120003293 | EX | 2007 | 0 | -375 | 0 |
43 | 1120003293 | EX | 2007 | 1 | 500 | 116,937288 |
44 | 1120003293 | GR | 2007 | 0 | -375 | 0 |
45 | 1120003293 | GR | 2007 | 5 | 500 | 116,088288 |
46 | 1120003293 | HA | 2007 | 0 | -375 | 0 |
47 | 1120003293 | HA | 2007 | 5 | 500 | 116,088288 |
48 | 1120003293 | SP | 2007 | 0 | -375 | 0 |
49 | 1120003293 | SP | 2007 | 5 | 500 | 116,088288 |
50 | 1120003293 | WI | 2007 | 0 | -375 | 0 |
51 | 1120003293 | WI | 2007 | 5 | 500 | 116,088288 |
52 | 1120003303 | DY | 2008 | 0 | -495 | 0 |
53 | 1120003303 | DY | 2008 | 2 | 500 | 118,177641 |
54 | 1120003303 | EX | 2007 | 0 | -495 | 0 |
55 | 1120003303 | EX | 2007 | 1 | 500 | 122,509566 |
56 | 1120003303 | GR | 2008 | 0 | -495 | 0 |
57 | 1120003303 | GR | 2008 | 2 | 500 | 118,177641 |
58 | 1120003303 | HA | 2008 | 0 | -495 | 0 |
59 | 1120003303 | HA | 2008 | 2 | 500 | 118,177641 |
60 | 1120003303 | SP | 2008 | 0 | -495 | 0 |
61 | 1120003303 | SP | 2008 | 2 | 500 | 118,177641 |
62 | 1120003303 | WI | 2008 | 0 | -495 | 0 |
63 | 1120003303 | WI | 2008 | 2 | 500 | 118,177641 |
Tabellendarstellung in Foren Version 5.5
Vielen Dank im Vorraus