Lead with offset

[ps3101]

Hi guys how can I take lead of marks as 92 

for student_id=1 and subject=chemistry I want the lead as 92 which means it should the marks of math of student_id 1

[binuacs]

@ps3101 

[ps3101]

Thanks but this is not the exact way for this solution in my opinion 

[ps3101]

Thanks for helping but this is not a reliable way to get solution in my opinion

[binuacs]

then you have to post your expected result

[alexnajm]

I agree with @binuacs - this is the solution I would do, and we need clarity on your expected output to help further

[ps3101]

How can we use lag(marks,2) in alteryx?