Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Filter Advanced Account Forecasts

Filter Advanced Account Forecasts

Declutter your advanced account forecast data to focus on the key forecasts. Filter your forecast data by dimensions and time periods by using standard filters. You can also filter your data by the list views on the Advanced Account Forecast Fact object by using advanced filters.

Required Editions

Available in: Lightning Experience
Available in: Enterprise, Unlimited, and Developer Editions
User Permissions Needed
To modify advanced account forecasts Read and Edit permissions on Advanced Account Forecast

Filter Advanced Account Forecasts by Dimensions and Periods

Use standard filters to view advanced account forecast data by time periods and dimensions.

  1. From the App Launcher, find and select Advanced Account Forecast Set Uses.
  2. Open the record that you want to create the standard filters for.
  3. On the Advanced Forecast tab, click filter icon.
  4. Select Standard.
  5. Specify the values for the dimensions.
    For example, Product.
  6. If necessary, select a time period.
    Time Period Description
    Current Periods Shows the forecasts for the current and seven subsequent months.
    Range Shows the forecasts for a date range.
    Set Periods Shows the forecasts for selected periods.

    Keep in mind that when you specify a dimension and a time period, you see only the data that meets both the criteria.

  7. Click Apply.

After you apply the filter, you can view the advanced account forecast data filtered by the specified criteria.

Filter Advanced Account Forecasts by Forecast Fact List Views

Use advanced filters to view advanced account forecast data filtered by the list views that you create on the Advanced Account Forecast Fact object. You can create list views that filter Advanced Account Forecast Fact records based on sophisticated filter criteria. Then, on the advanced account forecast set use record, you can use the advanced filter to filter the forecast data by the Advanced Account Forecast Fact list view.

To use advanced filters, first create a list view on the Advanced Account Forecast Fact object. Define your list view filter criteria by specifying the desired fields on the Advanced Account Forecast Fact object, operators, and logic statements. See Create or Clone a List View in Lightning Experience. You can't use the list views of a custom forecast fact object to filter advanced account forecasts.

  1. From the App Launcher, find and select Advanced Account Forecast Set Uses.
  2. Open the record that you want to create the advanced filters for.
  3. On the Advanced Forecast tab, click filter icon.
  4. Select Advanced.
  5. Search and select an advanced account forecast fact list view.
  6. Click Apply.

After you apply the filter, you can view the advanced account forecast data filtered by the selected list view.

Example
Example

A manufacturing company sells products in two locations: New York and Singapore. They sell products under two product categories: Hammers and Compactors. Here’s how they set up advanced account forecasting.

  • Dimensions: Location and Product Category
  • Measures: Order Revenue, Order Quantity, and Adjusted Order Revenue
  • Period frequency: Monthly
  • Start date: January 1, 2022
  • End date: December 31, 2022

The forecast for their partner account, Acme, has twelve monthly periods starting from January 1, 2022 and ending on December 31, 2022. The forecast has 48 forecast fact records (12 periods * 2 locations * 2 product categories).

The account manager for the manufacturing company wants to view the forecasts for only the Compactor products in Singapore. To see this data, the account manager create a list view called Compactors Singapore 2022 on the Advanced Account Forecast Fact object with these filters.

  • Location equals Singapore
  • Product Category equals Compactor

To view the forecast data for the Compactor products in Singapore, the account manager opens the Advanced Account Forecast Set Partner record for Acme and selects the Compactors Singapore 2022 list view for the advanced filter.

 
Loading
Salesforce Help | Article