My mistake regarding including Target values, that filter should have been included in the pivot table (you could do it yourself by fitering Attribute for only Production).
Regarding showing only which m/c produced most, there are many instances where 2 machines produced the same Max (operator 101833 on 2/2/2023 produced the max of 80 on both machines A3 and A4). What do you want to see?
Your last column Total Produc will only show the sum of the machines which produced the max (ignoring all other machines); is this really what you want to see?

Separately, in your picture, there are some numbers which I haven't seen; does this mean you succeeded in interrogating other files apart from the one you attached? If so that's great!

Pending your needs, so far I've got it to look like this:


2023-06-21_133138.jpg


And one more important thing, which version of Excel are you using? Does it have available such functions on the worksheet as FILTER, TOCOL and XMATCH?