Alerts based on Last Week's data

[KJM]

Hi all,

Our App has Sales information, and populates weekly so we can check individual store sales by week (Week 1, Week 2 etc.).

How can I set up an alert to let me know if Last Week's sales were less than X rather than specifying an actual week number?

Thanks.