Copy values depending on column

[Juan Pablo Melgarejo Zamora]

Hello,

I have something like this, and I'd like to get what is in the NEW_COLUMN, which is the substraction of the last trial - the first one per Name:

 

 

 

Trial

Name

Value

NEW_COLUMN

 

 

1

Paul

200

 

 

 

1

Mario

100

 

 

 

1

Louisa

59

 

 

 

2

Paul

150

50

 

 

2

Mario

99

1

 

 

2

Louisa

55

4

 

 

 

I've tried doing it with over, but it has been impossible so far.

 

Thanks,

Juan Pablo.

[Alain Martens]

Hi Juan,

Give thiscalculated column a try:

[Value] - Last([Value]) OVER ([Name])Thatwill give you this result:

 

Best regards,

Alain