2 Replies Latest reply on Dec 14, 2016 8:43 PM by Yvonne Cheng

    How to show latest information as per date

    Yvonne Cheng

      Hi All,

       

      I have a set of data as attached sample. I would like to have latest status at crew IPN level according to from date. I created calculated field: {FIXED [CREW_IPN]:MAX([FROM_DATE])}

      However, some crew it show 2 statuses ( I want only one latest status).

       

      Taking CNSC80/91 example, it should show terminated and resigned only respectively. Actually in the data source, these are latest status as per from date.

       

      Appreciate someone could help me, thanks.