Forum Discussion
how to
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 |
3 Replies
Hi Anonymous,
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
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
