Update pay rate from certain date

[Caz2bee]

So i need to change they pay rate for all staff, but on from a certain date, the older dates need to stay as they are currently. How do i do this, its driving me nuts!!!

 

[Rijnsent]

HI Caz2bee,
welcome to the forum. Most probably the easiest way to solve this issue is to go back to the source data of your pivot table and add a column there with the new rates. With the screenshot you shared there's not enough information to solve it other ways.
Cheers,
Koen