It would be great to have alerts trigger for a single line item.
Rule: When Revenue > $10,000
Total sales for the month are within revenue expectations of $50,000. All orders hover around $5,000 in revenue; however, one order has $25,000 worth of merchandise.
Current functionality: The alert will only trigger when the top 1000 records, all records or a specific orderID equals or is greater than $10,000. The alert would fire, however, because sales are within the expected range there would be no reason for concern.
Required functionality: Alerts should have the functionality to fire when ANY line item is greater than $5,000. The filter should go beyond the restrictions of top 1000 records, all records or a specific item because they really only cover a very limited scope of scenarios.