Pivot table guidance required

HansVogelaar if Target for 5 days is 5000 and achievement is 4500 in 5 days, 500 would remaining Target to achieve. This 500 would be Target for 6th day onwards.

I want pivot table to ignore target for day 6 which is 500, but consider only the achievement of day 5 + Day 6 and provides the result. For Example: if coverage for day 5 is 4500 and for day 6 is 200, so total achievement should be 4700/5000, not 4700/5500.

I hope you understand my question now. I do not want to use VBA as this would increase the file size and I do not have any expertise in PowerQuery or Powerpivot.