How to solve this??

[ecabanas]

Hi

I have a table with my sales like:

SalesID	Date	Customer
PV001	01/01/2015	A
PV002	02/01/2015	B
PV003	03/01/2015	C
PV004	01/02/2015	A
PV005	02/02/2015	C
PV006	03/02/2015	D

and I want to create a table with the customer and the date of his first order like this:

Customer	Date
A	01/01/2015
B	02/01/2015
C	03/01/2015
D	03/02/2015

Anyone knows how to do it?

Many many thank's

Eduard

[alexandros17 · Accepted solution]

if your table's name is for example MyTab then:

Load Customer. Min(Date) as FirstOrder resident myTab Group by Customer;

let me know

[MK_QSL]

Create a Straight Table

Dimension

Customer

Expression

Date(Min(Date))

[ecabanas]

Great!!! many thank's