2 Replies Latest reply on Nov 30, 2016 2:48 PM by Supriya Salunkhe

    Recent date for each row.

    Supriya Salunkhe

      Hi,

      I'm trying to get mist recent date for each row. The following image shows the blocks in blue.

      Eg: in the first one, I want to show only November 30, 2016

      in the second one, I want to show only November 30, 2016

      and in the last one, October 31, 2016.

       

      Any idea how to do that?

       

      I tried

      [TransactionDate] == {fixed: max([Transaction Date])

       

      but it took the max date available overall and displayed that for all the records.

       

       

      note- sorry for the image. I couldn't get the whole sheet as the data is confidential.