4 Replies Latest reply: Apr 24, 2018 6:21 AM by Tomasz Truszkowski RSS

    How to return a specific value based on the latest date of record

    Sergey Vsevolozhskiy

      HI!

      I have a table with many lines and columns,

      One of the columns is “date of entry”  another Column “Production Department” and another one is “Product Name”

      How can I return latest entry (latest “date of entry” ) for „Product Name“ based on the “Production Deprtment”

       

      date of entry

      Production Department

      Product Name

      1. 18.04.2018

      MF1

      A

      1. 18.04.2018

      MF2

      A

      1. 18.04.2018

      MF3

      B

      1. 19.04.2018

      MF1

      C

      1. 19.04.2018

      MF2

      D

      1. 19.04.2018

      MF3

      B

      1. 19.04.2018

      MF4

      E

       

      1. e.g.

      IF I chose MF1 I need to see product C

       

      Many thanks in advance!

      Sergey