The excel file has 4 columns Product, Date, Year (calculated based on the
date), Price.
For some Products price appears more than once in a year.
I need the year wise price breakup for each of the products based on the
latest date of the year. E.g: Product X has prices on dates 1/3/2007 and
3/31/2007 I need the price of 3/31/07. When I try creating a pivot, if there
are more than one price in a year, it gets added up whereas I need the latest
price for that year. How do I pick up the price based on latest data in a year