
8 respuestas
This would be advanced report filters with filter logic. You'll need to create 3 filters one for opportunities:
1. Amount greater than $100,000
2. Country is Germany or United States
3. Amount greater than 50,000
Then add Filter Logic be selecting "Filter Logic" from the report filter picklist option. You will get a type of formula field that will allow you to group filters. It will start as "1 AND 2 AND 3" but you'll want to edit it to read "(1 AND 2) AND 3." This will group the the 100K and Germany/US requirements while applying the 50K to all opps.