4 Replies Latest reply: Feb 13, 2018 4:08 PM by Fabien Girardin RSS

    Display latest value using last date

    Fabien Girardin

      Hello everyone !

       

      I have a table containing order N°, Order date, Item, State, State Date

       

      I would like to be able to display only the latest STATE of the ITEM based on the date

       

      At the moment, the pivot table looks like this

       

      ___________________________________________________________

          ORDER N°          ITEM          STATE          STATE DATE

                                      AAA1            403                    01.01.2018

            0001                  AAA1            407                    05.01.2018

                                      AAA2            403                    06.01.2018

                                      AAA3            403                    02.01.2018         

                                      AAA3            407                    03.01.2018

      __________________________________________________________

       

           0002                  BBB1            403                    06.01.2018

                                      BBB1            407                    08.01.2018   

                                      BBB2            401                    31.12.2017

                                      BBB2            403                    02.02.2018 

      ___________________________________________________________

       

      The table should only display States that are the most recent >

       

      AAA1     407

      AAA2     403

      AAA3     407

      BBB1     407

      BBB2     403

                     

      Thank you for your help