Product a has Vendor__c = x
AND
Product b has Vendor__c = x
AND
Product c has Vendor__c != x
Example: there are three accounts. 2 have three assets, 1 has one asset.
Account 1 has the following assets
Product Vendor__cproduct a x
product b x
product c y
And Account 2 has the following assets
Product Vendor__c
product a x
And Account 3 has the following assets
Product Vendor__cproduct a x
product b x
product c x
She *only* wants to see Account 1. Can anyone help me with this? I created a tabular report, but my filter logic doesn't work because it is comparing the AND clauses for a single asset record. I need to compare the group of asset records in each account.
5 risposte
report filters
Filter 1 vendor equals x
Filter 2 Product equals a,b
Filter 3 vendor Not equals x
Filter 4 Product equals c
Filter Logic (1 AND 2) OR (3 AND 4)
