output the last date

[crainerc]

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.

[johnw]

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.