Chat with us, powered by LiveChat

Report Filters

How to Use Report Filters in Salesforce

Report Filters

There can be a lot of records in Salesforce, so it's important to know how to add a filter to a report so you can display only the records you want.

Filter Records You Own

One of the more common filters is to display all records or only those you own.

  1. Click the Show list arrow.
  2. Select the type of records you want to display.
    Filter by One Field

Now Salesforce displays only the selected type of records.

Filter by Date

You can also filter by date. First you need to specify which date field you want to filter by.

  1. Click the Date Field list arrow.
  2. Select the date field you want to filter.
    Filter by One Field

    Next, you need to specify a date range.

  3. Specify a date range by clicking the Range list arrow and selecting an option.
    Filter by One Field

Now only records that were modified during the selected date range appear in the report.

Filter by a Field

You can also filter by adding any field to the Filter area.

  1. Click and drag the field you want to filter by from the Fields area to the Filter area.
    Filter by One Field
  2. Specify the filter criteria for the field.
    Filter by One Field
  3. Click Insert Selected to close the lookup dialog box.
    Filter by One Field
  4. Click OK.
    Filter by One Field

The report will only display records that include the fields you specified.