how to sort data by most recent date

[Amardep1010]

Hi Frank,

in below table i have 143 Rows, in my data product data is having duplicates as well., with different "Target Expiry Date".

Here i wish to sort data by most recent "target expity date " without loosing product ID count which is 143. also please note i have multipal sheets whicj linked with Product ID each other. also i am not getting 143 rows data from mapped table it shows less data then expected rows 143. please guide me on this as well.

Thank you

Product ID	Region	Country	City	Lease End Date	Project QTR-FY	Target Expiry Date	Type	STATUS	Rank
ABC_PF1062	CALA	PANAMA	PANAMA CITY	31-Oct-18			MD	NO ACTION	4
ABC_PF1081	APAC	SINGAPORE	SINGAPORE	31-Jul-19	Q4-2018	2-Jul-18	About to Closing	COMPLETE	5
ABC_PF1081	APAC	SINGAPORE	SINGAPORE	31-Jul-19	Q4-2020	30-Sep-20	Renew	Z-REJECTED	1
ABC_PF1237	USA	UNITED STATES OF AMERICA	NORFOLK	31-Oct-20			MD	NO ACTION	4
ABC_PF4452	USA	UNITED STATES OF AMERICA	OKLAHOMA CITY	20-May-18	Q3-2018	13-Jun-18	About to Closing	COMPLETE	5
ABC_PF4499	USA	UNITED STATES OF AMERICA	COPPELL	7-Jul-19	Q4-2019	7-Jul-19	Close	APPROVED	3

[v-yuta-msft]

Hi Amardep1010,

What's the relationship between the posted table and mapped table? Does the mapped table have same count of Product ID values?

Regards,

Jimmy Tao

[Amardep1010]

 In other reports product ID is common value which i used as "text" to built relation. 

Yes all tables has mapped value as "product ID"

[Amardep1010]

can anyone help me on this?