Extract data record from max date

[eptaqlik]

Hello,

please someone can help me?

I want to extract from a file:

for any material code the last data, qty and price from a lot of movement.

material	data	qta	Price
a	17/01/2017	1	10
a	18/01/2017	2	11
a	19/01/2017	3	12
a	20/01/2017	4	13
a	21/01/2017	5	14
b	21/02/2017	5	20
b	22/02/2017	4	21
b	23/02/2017	3	22
b	24/02/2017	2	23
b	25/02/2017	1	24
c	17/03/2017	1	30
c	18/03/2017	2	31
c	19/03/2017	3	32
c	20/03/2017	4	33
c	21/03/2017	5	34
Result
a	21/01/2017	5	14
b	25/02/2017	1	24
c	21/03/2017	5	34

tks in advance.

Marco

[tresesco · Accepted solution]

Straight table:

Dim: Result

Exp1: Date(Max(data))

Exp2: FirstSortedValue(qta, -data)

Exp3: FirstSortedValue(Price, -data)

[eptaqlik]

many tks

It work very well.

have a nice day.

Marco

[eptaqlik]

many tks

It work very well.

have a nice day.

Marco