3 Replies Latest reply on Jan 30, 2018 10:59 PM by Zhouyi Zhang

    Lookup First Record value

    Kaushik Dutta

      Hi Guys,

       

      My dataset is this one, so basicly patient A visited the Hospital 2 times(1 Jan 2017 and 1 Jan 2018). I want a Calculated Field which will get the first status of the Patient id

      , so A has visited on 1 Jan 2017 at that time he was Registered user but, next year when he visited back he was New user(In this case I want to get the First Status of the particular Patient).

       

       

      I want this