I have a requirement to show All Accounts without open Opportunities (also report should all accounts without any opportunities as well).
Below are the steps I followed:
- I created a custom report type on Account (With or Without Opportunities) (which will result in all Accounts)
- Then created a new report by selecting this report type
- Added a cross filter " Accounts without Opportunities) (Until this point i am clear on the logic)
- (I found this step in one of the training docs) Added sub filter on opportunity "Closed equals False"
It returned all Accounts without any associated Opportunities and Accounts without Open Opportunities
I am not clear on how the second filter works i.e "Closed equals False" on opportunity
Can someone please clarify and elaborate on how the above filter works and how it is yielding all Accounts without Open Opportunities.