Hi Zhouyi Zhang,
Thank you for your kind reply,
The output should be based on month filter selection. If the user select a month as 'Nov 2018' from month filter and if the parameter is 3 months, then view should look which are the ID's had WL flag as 'Y' continuously for previous 3 months from the month of Nov 2018.
So the above result it is working fine for 3 month parameter selection. but it is not working fine for other parameter selections.
When i select 6 month value in the parameter the expected output should be 'nothing' becoz all the client ID's are not meet the condition that before Nov2018 there are no continuous WL flag as 'Y' for 6 months. this is same for 9 month and 1 year.
Suppose if user select the month filter as July 2018 and if the parameter is 3 month then nothing. and if parameter is 6 month then Client id 9 should display as its meets the condition that before july 2018 this ID 9 has continuous WL flag 'Y' for 6 months.
Thanks in advance,