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.
Please load the data into a Tableau Workbook and show us what you have tried and where you are stuck.
Remember to tell us the version of Tableau you are using.