Select row based on dates

[#1]

Hi I have a sample data below of what I'm currenty viewing & what I would like to view.

Current

Customer #	Customer Name	ItemlookupCode	Discount	SaleStartDate	SaleEndDate
1010	AA	9361	5%	1/07/2011	30/06/2012
1010	AA	9361	5%	1/07/2012	31/12/2012
1010	AA	9361	3%	1/1/2013	31/12/2013
1111	CC	6912	19%	1/07/2011	31/12/2012
1111	CC	6912	12%	1/1/2013	01/03/2013

This is what I need, basically the latest saleenddate is all I'm interested in to see what is the latest sale for a Item.

Not sure what type of expression will produce this output for me

Customer #	Customer Name	ItemlookupCode	Discount	SaleStartDate	SaleEndDate
1010	AA	9361	3%	1/1/2013	31/12/2013
1111	cc	6912	12%	1/01/2013	01/03/2013

[#2]

Thanks I tried it as a calculated dimension and expression gives me  //error in calculation for some reason.

[er_mohit]

see the file again here i use your item field in dimension side

[#4]

in pivot--

dimension1-[Customer #]

dimension2-[Customer Name]

dimension3-ItemlookupCode

expression1-FirstSortedValue(Discount,-Sale_EndDate)

eapression2-SaleStartDate

expression3-SaleEndDate