1 of 1 people found this helpful
Ideally we need a way to sort the column - do you have a date, or other ID that will result in the correct sort? If you do, then we can make sure rows don't get reordered in Tableau.
Either way we will be using a calculation similar to:
attr([Column 1]-zn(lookup(attr([Column 1],-1)))
The table partitioning will be set to table down if you don't have any way to explicitly sort the column.