Hey,
I already searched for my problem, but I couldn't make it work.
I have this table what you see on the bottom. I have to build the sum of amount but just the latest value.
E.G. : Material-No 26 had in 2011 an amount of 0 and Mat-No 384 in May 2005 an amount of 3 so the sum is 3. every other amount for the same materialnumber that is earlier is no longer relevant. My problem is that I just can take the newest value of every material-no and need to build a sum.
| Material-No | Year | Month | Amount | Value |
| 26 | 2009 | 12 | 10,000 | 80,00 |
| 26 | 2010 | 12 | 5,000 | 20,00 |
| 26 | 2011 | 2 | 0,000 | 0,00 |
| 384 | 2003 | 12 | 0,000 | 0,00 |
| 384 | 2004 | 12 | 0,000 | 0,00 |
| 384 | 2005 | 5 | 3,000 | 0,00 |
| 886 | 2003 | 12 | 0,000 | 0,00 |
| 886 | 2004 | 12 | 0,000 | 0,00 |
| 886 | 2005 | 8 | 0,000 | 0,00 |
| 3703 | 2009 | 12 | 0,000 | 0,00 |
| 3703 | 2010 | 12 | 0,000 | 0,00 |
| 3703 | 2011 | 4 | 0,000 | 0,00 |
| 9541 | 2003 | 12 | 0,000 | 0,00 |
| 9541 | 2004 | 12 | 0,000 | 0,00 |
| 9541 | 2007 | 12 | 1,000 | 15,00 |
| 9541 | 2008 | 12 | 1,000 | 15,00 |
| 9541 | 2009 | 8 | 1,000 | 15,00 |
| 9621 | 2003 | 12 | 0,000 | 0,00 |
| 9621 | 2004 | 12 | 0,000 | 0,00 |
| 9621 | 2007 | 12 | 1,000 | 15,00 |
| 9621 | 2008 | 12 | 1,000 | 15,00 |
| 9621 | 2009 | 8 | 1,000 | 15,00 |
| 9631 | 2003 | 12 | 0,000 | 0,00 |
| 9631 | 2004 | 12 | 0,000 | 0,00 |
| 9631 | 2007 | 12 | 1,000 | 15,00 |
| 9631 | 2008 | 12 | 1,000 | 15,00 |
