I am trying to display more than just a static date on a pivot table but rather until date

See the images or workbook below

Capture1.PNG
Capture.PNG
excel help.xlsx


What I am trying to do is when it displays a date that it would show the total until that date (I.e it should display all sales persons name and their total sales up until that date)