1 Reply Latest reply on Sep 18, 2018 2:09 PM by Patrick A Van Der Hyde

    Employee who changed one information/flag from one quarter to another quarter

    kavi ram

      Hi,

      Please help to achieve the below scenario,

      Employee A is in default in Q4 2017 ( Status = Y) and is not in default anymore in Q1 2018 (  Status = N).

      Employee B is in default in Q4 2017 (Status = Y), and is still in default in Q1 2018 (Status = Y).

      Employee C is not in default in Q4 2017 (Status = N), and is in default in Q1 2018 (Status = Y).

      I would like to see the result at quarter level for employee A & C where the Flag has changed  as 'Y to N'  and  'N to Y' and also for Employee B as 'No change' for the selected year

      I have attached the excel sample data.

       

      Thanks in Advance.

      Kavi