I am curious if you are able to share a workbook with the data in it? That can sometimes be more beneficial to the members of the community to attempt to help with!
Though, what I believe is happening has to do with the sorting that is set for the view. I would review the following product help section on sorting. How to Sort Data (Computed Sorts)
I hope this helps!