max date based on status

[Kumar6872]

Hello All,

I have a below table

Product_ID        Product_Status    ProductTracking_Date
A                               Dispatched          Jan 1 2019
B                               Dispatched         Jan 3 2019
C                               In Transit             Jan 4 2019
A                                IN Transit            Jan 15 2019
A                                In transit             Jan 30 2019
A                                In Transit             Feb 2 2019
A                               Delivered             Feb 14 2019

I want data to be displayed based on product status "In Transit" max date

Product_ID        Product_Status    ProductTracking_Date
A                              In Transit                  Feb 2 2019
C                             In Transit                   Jan 4 2019

Thanks in Advance.

[Vengatesh]

Add Product ID and Status as Dimension.

Add Expression: Max({<Product_Status={'In Transit'}>}ProductTracking_Date)

[Brett_Bleess]

Did the post above solve your question?  If so, be sure to return to the thread and use the Accept as Solution button on that post to give the poster credit for the assistance and let other Community Members know it worked.  If you are still working on things, leave an update as to what you still need.

Regards,
Brett