You can create a table calculation as depicted below. For sending out the alerts based on this condition, you can refer: Send email alerts to anyone on any condition with VizAlerts | Tableau Software
Hope this helps.
Thanks for your speedy response. Is it possible for you to send the working file?. When i try to implement that same, I am finding no option given to choose the level and restarting parameter as suggested.