Please find the sample application and some scenarios also i am attaching for more understanding.
Scenario 1 : the below which i have highlighted this product should removed in this scenario , if they selected from JAN-2017 to AUG-2017 then this product should be appear.means after value we should consider consecutive three months is zero then remove the SKUs.
Scenario 2: here also i have highlighted yellow color
I have tried that is also but it is not working, i am assuming we need to create the flag and count the consecutive three months is zero then we have to remove the entire row which is based on selection period.
Thanks Sunny, ARENA180BK this SKU should stay why because Nov-2017 month have the value. Here logic is from max month to last three months continuously data is zero then we need to hide the row, this selection period also as per mind set it will change. So we should hide these rows ARENA180MW,ARENA 180 BLANC,ARENA180BLK,ARENA180BK -Z,ARENA180WH. We should not hide the ARENA180BK only.