Pivot table to take data for latest date

Hi,

 

I need help with creating pivot table with attached excel. (actual sheet has more than 1000 rows, attached sheet is just sample data)

For InputFile, I have to consider data for latest date.

For example: Log 8 has multiple rows but I want data corresponding to latest date (highlighted in green) to be considered in pivot table. 

 

 

Kindly help!