As a system admin, I was working on opportunity reports in Salesforce. Recently, the sales team wanted to analyze the sales of some states. For that, they want a report of closed won opportunities only for those states, excluding other states. So, instead of applying a filter for each state differently, I have used multiple value filters in the Salesforce report.
Here, I will explain what a multiple-value filter is and its uses. Then, we will explain step by step how to filter multiple value in Salesforce Report.
Multiple Values Filter in Salesforce Report
In the Salesforce report, when we want to search multiple values for the same field, instead of applying a filter for each value separately, we can use a multiple values filter to search for more than one value. This filter will return the records that contain the value that we entered.
When we want to add multiple values to a filter value, we need to use a comma to separate the values. After applying the filter, it will return those records that contain the value you entered while applying the filter.
Uses of multiple values filters in Salesforce:
- This allows us to search for more than one value at a time, which saves time when creating reports.
- This enables the user to narrow down our data and makes it more straightforward to analyze data. It makes our task easier.
- Using this filter helps to reduce complications and lengthy processes.
Filter Multiple Value in Salesforce Report
Suppose in the opportunity object you want to search multiple Billing States/Province, then instead of applying a filter for each value, we can use a search multiple value filter. Using this, we don’t need to apply a filter to all values.
In the following steps, I will explain how to filter multiple values in a Salesforce report.
To create the record in Salesforce Org, log in to your Salesforce account and follow the below steps.
1. Go to the Home Page, then click the App Launcher. In the search box, search for the Report and click on it.
2. To create a new report, click on the New Report button.
3. Now, you need to select the Object to create the report. In the Category option, click All and search for the Opportunities object. Then click on the Start Report button.