all arrival, first, second etc

[andyrebs]

Hi,

I have this request. I have this data sheet:

order n°	Product	date
00001	d0101	05-02-2014
00002	d0101	25-02-2014
00003	d0101	16-03-2014

I would have a pivot table as shown

product	first arrival	second arrival	third arrival
d0101	05-02-2014	25-02-2014	16-03-2014

I hope somebody can help me.

Many thanks

Andrea

[tresesco]

Take straight table, dimension product,

first expression: Max(date)

second expression: max(date,2)

third expression: max(date,3)