Pivot table to take data for latest date

[Deleted]

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!

[#2 · Accepted solution]

Hi,

That kind of does what you want, but I had to convert CVS to excel format.

You'll probably need to tweak it to work flexibly.

Regards, Jarek

[#3]

Thanks! I will check this :)