If you check on the attached, ValidateData sheet. I moved the Moved from On Hold on the Text shelf , switch it to continuous (right-click the pill - select Continuous) . Next I added a quick table calculation - Running Total on it.
I also created a filter - keep only last row , which returns True on the last row having the running-total you are looking for.
Next I created a Header for the column.
On the final view, it's a duplicate of this sheet , except that I moved the filter on the filter shelf , compute Table down , and keep the True value. And I hide the Rows dimensions header (right-click Rows blue pill and unselect 'Show Header'.
Thank you! This is exactly what I was looking to achieve. Thanks for the detailed explanation.