Have been trying to crack this for a long time. Would highly appreciate any help. I have a lookup similar to this: Merchant_ID Amount_threshold Count_threshold Description Merchant1 15 1 ABC Merchant2 11 5 XYZ Merchant3 25 5 LMN * 13 1 all_other_merchants And my events are: Merchant_ID Amount Merchant1 10 Merchant1 20 Merchant2 10 Merchant3 40 Merchant7 30 Merchant7 20 I want my query to return something like this: If for each merchant: Total_amount>amount_threshold AND count>count_threshold Then show it in the table below Merchant_ID Description Total_amount Total_count Amount_threshold Count_threshold Merchant1 ABC 30 2 15 1 Merchant7 all_other_merchants 50 2 13 1 Update: Added a new case - a wild card merchant ID that captures all merchants not explicitly specified in the lookup and applies thresholds to that merchant. ... View more