You need to sign in to do that
Don't have an account?
RITZ
Report Filter on child object
I need to put a filter in report based on Loan and Loan Team Member , Role object.The report should only show Loans where none of the Loan Tember role is 'Loan Specialist' so even if there is a Loan with two Loan Team Members one with Loan Specialist role an another with a different role , the parent Loan should not be visible in the report.How to achieve this.I have put the filter of Role <> 'Loan Specialist' but its showing those loans as well where there are multiple Loan TM and one has a role of Loan Specialist
To achieve the desired filtering in Salesforce report based on Loan and Loan Team Member Role object, you can use a combination of filter criteria and a cross filter.
First, add a filter criteria for the Loan Team Member Role object to exclude all Loan Team Members with a role of 'Loan Specialist'. This will exclude all Loans where there is at least one Loan Team Member with a role of 'Loan Specialist'.
Secondly, add a cross filter to exclude all Loans where at least one Loan Team Member has a role of 'Loan Specialist'. This will exclude all Loans where there is at least one Loan Team Member with a role of 'Loan Specialist', regardless of the roles of other Loan Team Members.
- Open the report in the report builder.
- Click on the 'Add' button in the 'Filters' section of the report builder.
- Select 'Loan Team Member Role' from the list of available objects.
- Select 'Role' from the list of available fields.
- Select 'not equal to' from the list of available operators.
- Enter 'Loan Specialist' in the 'Value' field.
- Click 'OK' to save the filter criteria.
- Click on the 'Add' button in the 'Cross Filters' section of the report builder.
- Select 'Loan Team Members' from the list of available objects.
- Select 'Role' from the list of available fields.
- Select 'equals' from the list of available operators.
- Enter 'Loan Specialist' in the 'Value' field.
- Check the 'Exclude' checkbox to exclude all Loans where at least one Loan Team Member has a role of 'Loan Specialist'.
- Click 'OK' to save the cross filter.
- Once you have added these filter criteria and cross filter, the report will only show Loans where none of the Loan Team Members have a role of 'Loan Specialist'.
Try these steps for filters. hope its help.