Apply additional filters

Add filters to refine the opportunities and hierarchies that participate in calculating the forecast values.

License and role requirements

Requirement type You must have
License Dynamics 365 Sales Premium or Dynamics 365 Sales Enterprise
More information: Dynamics 365 Sales pricing
Security roles System Administrator or Forecast Manager
More information: Predefined security roles for Sales

Filter hierarchy records in the forecast

You can filter your forecast to include only those hierarchies that meet the specified conditions. For example, Kenny Smith, the Sales head for APAC and EMEA wants to view the forecast data of the org in the APAC territory. As an administrator, you can create an org chart forecast and set the hierarchy filter to include only the APAC forecast data.

The following screenshot illustrates a sample forecast hierarchy:

A sample forecast hierarchy with a manager and her team.

To filter hierarchy records in a forecast

  1. In the General step of the forecast configuration, select the Funnel icon next to Hierarchy entity field.

    Note

    To apply the filter on an existing forecast, clone the forecast configuration, apply the filter, and activate it. You can then deactivate the old forecast configuration.

  2. Select the conditions to filter the hierarchy that you want to include in the forecast. For our example, let's select Territory is equal to APAC. This will include forecast records of sellers from APAC.

    Screenshot of the filter hierarchy page.

    Note

    If a parent record is filtered out of the hierarchy, the rollup value of the child records will show up under the parent record. However, the opportunities that were directly owned by the parent record won't be displayed in the forecast. Let's suppose that Dustin Ochs is a Sales Manager in Kenny's org who manages two sellers. Henry is in Europe, but manages sellers in APAC. When Kenny looks at the forecast for APAC, the opportunities of Dustin's reports will roll up under Henry's name, but the forecast won't show the opportunities owned by Henry.

  3. Select a value that will be at the top of this forecast hierarchy in the Top of Hierarchy drop-down. You'll see a preview of the hierarchy after applying the filter conditions.

    Screenshot of the forecast hierarchy preview.

    If a parent record is suffixed with (group) in the preview, it means that the parent record is filtered out of the hierarchy but its child records are included in the hierarchy. As an example, see Dustin's record in the above screenshot.

  4. Ensure that the forecast hierarchy looks correct before you activate the forecast. After the forecast is activated, you can't edit the filter.

Add additional filters on opportunities to calculate forecast values

Using the rollup filters, you can filter opportunities that participate in calculating the forecast values. To filter opportunities, create filter conditions based on the opportunity and its related entity attributes.

For example, you know that opportunities related to ADatum Corporation and the revenue of more than $10,000 can't be closed for the current quarter. To filter out such opportunities from the forecast, follow these steps:

  1. In the General step of the forecast configuration, select the Funnel icon next to Rollup entity field.

  2. Select Add > Add row.

  3. In the selection boxes, select the attribute as Potential Customer, the condition as Does Not Equals, and the account name as ADatum Corporation.

    With this condition, the opportunities related to Adatum Corporation will be removed from the forecast. In the next step, you'll add a condition to filter revenue that's more than or equal to $10,000.

  4. Select Add > Add row.

  5. In the selection boxes, select the attribute as Est. Revenue, the condition as Is greater than, and revenue to be considered as 10000.

    Enter the second condition.

  6. Select Apply to save the filter conditions.

When the forecast is activated, the query will be executed to filter the forecast for the added conditions.

Can't find the options in your app?

There are three possibilities:

  • You don't have the necessary license or role. Check the License and role requirements section at the top of this page.
  • Your administrator hasn't turned on the feature.
  • Your organization is using a custom app. Check with your administrator for exact steps. The steps described in this article are specific to the out-of-the-box Sales Hub and Sales Professional apps.

Configure forecasts in your organization
View a forecast