how to

[Amardeep100115]

Hi There,

Please guide me on below query Please

I have a table and would link to filter this table with rank according to date and display data without losing product count. If there are multiple products are having same lease end date and different critical date then show only upcoming date details with same product count

Product ID	Total Sale	Project Timeline QTR-FY	Critical Date	Lease End Date
0071		Q4-2018	05/09/19	11/09/19
1062			07/31/19	10/31/18
1081	$112,835	Q4-2018	05/31/18	07/31/19
1081	$112,835	Q4-2020	07/31/22	07/31/19
1237	$6,470		04/30/19	10/31/20
4452	$13,315	Q3-2018	01/31/19	05/20/18
4499	$274,681	Q4-2019	07/07/19	07/07/19
6216	$29,218	Q1-2021	10/30/20	10/30/20
6218	$221,176	Q1-2021	10/30/20	10/30/20
6492			05/31/21	05/31/21

[v-danhe-msft]

Hi @Amardeep100115,

From your description, I could not understand what your desired result? Could you please offer me more information or post your desired result picture if possible?

Regards,

Daniel He

[Amardeep100115]

HI There,

Sorry for not replying late.

I wish to filter upcoming project  by project date in the below table i have highlighted the part where the one project is completed and another is upcoming. i wish to be see upcoming project and another should not be in table but it shouuld be at bottum of the table or get filtered by date. one thing  need to be keep in mind that I have 143 Project rows and uniqe ID is 129 which should not get disturbed.

Hoope you got my requirement

[Amardeep100115]

Can i have guidance on my query? Please