Juan Pablo Melgarejo Zamora Posted June 28, 2019 Share Posted June 28, 2019 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. Link to comment Share on other sites More sharing options...
Alain Martens Posted July 1, 2019 Share Posted July 1, 2019 Hi Juan, Give thiscalculated column a try: [Value] - Last([Value]) OVER ([Name])Thatwill give you this result: Best regards, Alain Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now