Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created the following Table.
ArtNr | ab | VK1 | VK2 | VK3 | VK4 | VK5 | EK | PG | KR |
22000001 | 07.06.2005 | 3,89 | 4,09 | 3,69 | 4,25 | 4,45 | 1,4 | 3 | 85 |
22000001 | 03.01.2007 | 3,09 | 3,25 | 3,39 | 3,55 | 3,69 | 1,45 | 3 | 78 |
22000001 | 19.01.2007 | 3,09 | 3,25 | 3,39 | 3,55 | 3,69 | 1,45 | 3 | 78 |
22000003 | 10.05.2005 | 3,15 | 3,29 | 2,99 | 3,45 | 3,75 | 1,32 | 3 | 76 |
22000003 | 27.05.2005 | 3,15 | 3,29 | 2,99 | 3,45 | 3,75 | 1,32 | 3 | 76 |
22000013 | 26.04.2005 | 42,5 | 44,5 | 40,29 | 48,5 | 52,95 | 22,83 | 3 | 45 |
22000013 | 27.05.2005 | 42,5 | 44,5 | 40,29 | 48,5 | 52,95 | 22,83 | 3 | 45 |
22000013 | 08.06.2005 | 5,25 | 5,49 | 4,99 | 5,75 | 6,25 | 22,83 | 3 | 1 |
22000013 | 22.06.2005 | 40,29 | 40,29 | 40,29 | 40,29 | 40,29 | 22,83 | 3 | 45 |
The end result should look like this:
ArtNr | ab | VK1 | VK2 | VK3 | VK4 | VK5 | EK | PG | KR |
22000001 | 19.01.2007 | 3,09 | 3,25 | 3,39 | 3,55 | 3,69 | 1,45 | 3 | 78 |
22000003 | 27.05.2005 | 3,15 | 3,29 | 2,99 | 3,45 | 3,75 | 1,32 | 3 | 76 |
22000013 | 22.06.2005 | 40,29 | 40,29 | 40,29 | 40,29 | 40,29 | 22,83 | 3 | 45 |
Thanks a lot!
C.
If your "last date" doesn't need to respond to selections, the easiest might be to establish a new field during the load:
if(ArtNr<>previous(ArtNr),ab) as Lastab
...
ORDER BY ArtNr, ab DESC
And then use Lastab instead of ab as the dimension.