Pivot Table New Data Issues

Hi all!   I look after scheduled servicing for a earthmoving company. A big part of that is machine hours.   I have developed a pivot table that filters on all active machinery ID's and their res...