Display the items of the highest date per ID1/ID2-Combination in a straight table

[#1]

Hi,

i have a problem with the following data:

Table:

load * inline

[

ID1,ID2,Item,Date

1,AB,Apple,11.03.2016

1,AB,Cherry,11.03.2016

1,AB,Apple,12.03.2016

1,AB,Banana,12.03.2016

2,CD,Apple,09.03.2016

2,CD,Apple,10.03.2016

2,CD,Banana,10.03.2016

];

I want to display the items of the highest date per ID1/ID2-Combination in a straight table like this:

How do I do this?

[sunny_talwar]

May be this?

Dimension:

ID1

ID2

Item

Expression:

=If(Max(Date) = Max(TOTAL <ID1, ID2>Date), Date(Max(Date)))

[#3]

Thx for your reply!

I let you know if it worked with me.

[#4]

It worked!

Thx a lot!

[#5]

It worked! Thx a lot!