Are you looking something like this
if attr([State])='New York' and sum([Sales])>30000 then 'New York Sales exceeds 30k'
elseif attr([State])='Texas' and sum([Sales])>=10000 then 'Texas Sales exceeds 10k'
Yes, but I want to get an email alert if it reached the threshold. Is that possible?
Haven't had too much exposure to the alerts function yet - but if it is calc based, perhaps we could try this:
Create a calculated field based on Profit, with a condition on the category:
WHEN "New York" THEN IF SUM([Profit]) >= threshold1 THEN 1 END
WHEN "..." THEN IF SUM([Profit]) >= threshold2 THEN 1 END
Something along the lines like that.. then you can trigger the alert based on this calc. I've selected for a numerical output as I recall the data alert is driven by a continuous axis.
Let me know if this works!