Hi, I have a dataset like presented below: Brands Date Sales QTY %Delivery Adidas 5/15/2017 14000 19 45 Adidas 5/15/2017 1000 12 20 Adidas 5/16/2017 10000 5 35 Adidas 5/17/2017 6000 8 20 Adidas 5/18/2017 8000 17 18 Nike 5/16/2017 6000 8 12 Nike 5/17/2017 8000 13 10 Nike 5/18/2017 8000 13 11 - - I have data like above for different brands and their delivery percentage. The problem is I would like to loop through all the 100 brands and create a flag for each brand where %Delivery (last column) is 40% more than the last 5 day average. Thank you
... View more