what formula to use to calculate column taking the ascending timestamp from row above.

[eddy ng]

unsure how to explain this, hence will need the attached visual aid as an example.

The highlighted column "Parameter Change timestamp End 2" is the column i want to create.

As you can see i want to get the[Rig name] and take the [Parameter Change timestamp] above it into [Parameter Change timestamp End 2]

I've tried using:

Rank([Parameter Change Timestamp],[Rig Name])

First([Parameter Change Timestamp]) OVER (Intersect([Rig Name],Next([Rank])))

 

However,

there are some[Parameter Change Timestamp] that are the same, Hence value comes as NULL. (as the Rank is the same number)

And i want the next acsendingtimestamp withinthe Rig ID.