Hi, I'm trying to create a report that if an account has a particular asset, remove it from my report even though it has other assets. For example:
Company 1 has
Asset A
Asset B
Asset C
Company 2 has
Asset A
Asset B
Company 3 has
Asset A
Asset D
Asset F
I want to exclude all accounts that have asset C (even though they have other assets.) But right now, it still displays company 1 with 2 asset lines Asset A & Asset B. I just want the report to display Company 2 & Company 3 bc they doesn't have asset C.
What am I missing?
3 answers
Thanks @Steve Molis , appreciate the reply. I ended up stumbling across your other solution: https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A7oBVSAZ
and that worked! Added these cross filters:
