Alerts- Ranking System- have an alert when a new #1(Max)

bof

In our scenario we would like to have an alert when we have a new #1 store for daily or weekly sales.

Currently we have graphs that list our highest daily/weekly totals in descending order. So our top store in each category is at the top. We would like to be alerted when a new store breaks the record(becomes the new max).

 

I could also see the scenario being helpful in other industries and uses.