--- schema_version: "1" id: 26a395dc1cc12c749b560b5d89a480e6d10460b45a98f467944c7724fe9f3108 title: Preparing Sales Leaders to Report on Forecasts collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/forecasts3_reports_crt_understand.md canonical_url: https://help.salesforce.com/s/articleView?id=analytics.forecasts3_reports_crt_understand.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 554312b28ddf220cbcfa8e2f1e4c44a347e7201265dfb084435fee41bc2cac9f description: Unlock details about forecasts with and without adjustments, overall planned revenue, and quota attainment when you create custom report types for forecasting When you create a custom report type, choose the primary and related objects carefully, because they determine the forecast types you can report on. products: - Cross Cloud release: "264" --- # Preparing Sales Leaders to Report on Forecasts Unlock details about forecasts with and without adjustments, overall planned revenue, and quota attainment when you create custom report types for forecasting When you create a custom report type, choose the primary and related objects carefully, because they determine the forecast types you can report on. ### Required Editions

Available in: both Salesforce Classic and Lightning Experience

Available in: Professional, Performance, and Developer Editions and in Enterprise and Unlimited Editions with the Sales Cloud

This table lists the forecasting custom report types that you can create. When you create a custom report type, choose the primary and related objects carefully, because they determine the forecast types you can report on.

Primary Object	Use to Create a Report for...
Forecasting Custom Data	Viewing external data that’s added to a custom column. We recommend including all the default fields in the report type.
Forecasting Custom Data with Forecasting Items as a related object	Viewing the forecast compared to external data that’s available in a custom forecast column. For example, create a report that shows how your sales team is performing versus last year’s performance. Create a custom field that contains data about last year’s total revenue, and select that field in a custom column for your active forecast type. Create the custom report type that uses Forecasting Custom Data as the primary object and uses Forecasting Items as a related object. When you create the report, include the forecast owner, the team’s commit value, closed value, and the custom column.
Forecasting Items	Viewing information about forecasts. If you use a forecast type based on revenue, we recommend using these default fields in the report type. Owner Only Amount—The sum of a person’s revenue opportunities, without adjustments. For example, if you own two opportunities, each worth $10,000, the Owner Only Amount is $20,000. Amount Without Adjustments—The sum of a person’s owned revenue opportunities and the person's subordinates’ opportunities, without adjustments. Subordinates include everyone reporting up to a person in the forecast hierarchy. This amount is visible only on reports. For example, if the sum of the amount of all opportunities that you own is $20,000, and the sum of the amount of your subordinates’ opportunities is $55,000, the Amount Without Adjustments is $75,000. Amount Without Manager Adjustments—The forecast number as seen by the forecast owner. This amount is the sum of the owner’s revenue opportunities and the owner’s subordinates’ opportunities, including adjustments made by the forecast owner on the owner’s or subordinates’ forecasts. It doesn’t include adjustments made by forecast managers above the owner in the forecast hierarchy. For example, Anne has an Amount Without Adjustments of $75,000, made up of $20,000 of her own opportunities and $55,000 of opportunities owned by Ben, her subordinate. She adjusts Ben’s amount to $65,000 for a total of $85,000. If you adjust Anne’s number from $85,000 to $100,000, you see $85,000 in Amount Without Manager Adjustments because that’s the amount Anne sees. Anne can’t see your adjustments because you’re her manager. To see the amount that includes your adjustment to $100,000, look at Forecast Amount. Forecast Amount—The revenue forecast from the forecast manager’s perspective and the sum of the owner’s and subordinates’ opportunities, including all forecast adjustments. For example, you’re a forecast manager and have another forecast manager reporting to you who has an Amount Without Manager Adjustment totaling $85,000. If you adjust the forecast to $100,000, the Forecast Amount is $100,000. If you use a forecast type based on quantity, use these default fields in the report type. Owner Only Quantity, Quantity Without Adjustments, Quantity Without Manager Adjustments, and Forecast Quantity Regardless of whether you forecast based on revenue or quantity, add these fields. Has Adjustment—A checkbox that indicates whether a manager adjustment was made on an owner’s forecast. Has Owner Adjustment—A checkbox that indicates whether a forecast user has adjusted the user’s own forecast. If you use cumulative forecast rollups, add this field to your report. ForecastingItemCategory—This field indicates which rollup each forecast is for: Open Pipeline, Best Case Forecast, Most Likely Forecast, Commit Forecast, Closed Only, Pipeline, Best Case, Most Likely, Commit, or Closed. If you changed the forecast category cumulative rollup names, those changes appear in the ForecastingItemCategory values. If you group your forecasts using custom picklists, add these fields in the report type. Group Value: API Name—The developer name of the custom picklist value that’s selected in the forecast type. Group Value: Translated Name—The translated value of the custom picklist value selected in the forecast type.
Forecasting Items with Opportunities as a related object	Viewing opportunity revenue or quantity forecasts. View opportunity information for specific forecasting line items. For example, you can create a summary report for each of your subordinates that includes the opportunity names and last activity dates for their forecasting items and final forecasts. To include forecast adjustments, either use the Forecasting Items report type, or use the Forecasting Item with or without opportunities option. For opportunities with no opportunity products specified, this report type includes two forecasting items: one for the opportunity revenue forecast type and one with product family grouping. These product family forecasting items roll up into the Products Not Specified row of the product family forecast.
Forecasting Items with Opportunities and Forecasting Source Record Judgments as related objects	Viewing opportunities revenue or quantity forecasts with judgment values. For example, you can create a summary report for each of your subordinates that includes the opportunities and whether they were judged in or out as part of the forecast. Including forecast judgments in reports works best if you apply judgments in either role-based forecast hierarchy or territory hierarchy forecast types, not both. If you use manager judgments in both role-based hierarchy and territory hierarchy forecast types, users other than Salesforce admins see judgments made in the role-based hierarchy only.
Forecasting Items with Opportunity Splits as a related object	Viewing opportunity splits or custom split field forecasts. View opportunity split or custom split field information for specific forecasting line items. For example, you can create a summary report for each of your subordinates that includes the opportunity split amounts and percentages for their forecasting items, with adjustment information and final forecast amounts.
Forecasting Items with Opportunity Product as a related object	Viewing product family forecasts. View product family information for specific forecasting line items. For example, you can create a summary report for each of your subordinates that includes the product families and total price for their forecasting items, with adjustment information and final forecast amounts. This report type shows forecasting items for product family revenue, product family revenue by territory, and product family quantity forecast types. It includes opportunities with and without opportunity products specified.
Forecasting Items with Product Splits: Items with Products No Split and Opportunity Product Splits as related objects	Viewing opportunity product split forecasts that contain items that aren’t split. For example, create a summary report for each of your subordinates that shows the opportunities included in a forecast that don’t include split amounts or percentages. To see the entire product splits forecasts, create a joined report that includes this report type and these report types. Forecasting Items as the primary object with Product Splits: Items without Products as a related object Forecasting Items as the primary object with Product Splits: Items with Product Splits and Opportunity Product Splits as related objects
Forecasting Items with Product Splits: Items with Product Splits and Opportunity Product Splits as related objects	Viewing opportunity product splits forecasts that contain items that are split. For example, create a summary report for each of your subordinates that includes the opportunity product split amounts and percentages for their forecasting items, with adjustment information and final forecast amounts. To see the entire opportunity product splits forecasts, we recommend creating a joined report that includes this report type and these report types. Forecasting Items as the primary object with Product Splits: Items with Products No Splits and Opportunity Product Splits as a related object Forecasting Items as the primary object with Product Splits: Items without Products as a related object
Forecasting Items with Product Splits: Items without Products as a related object	Viewing opportunity product split forecasts that contain items that don’t include a product designation. For example, create a summary report for each of your subordinates that shows the opportunities included in a forecast that aren’t grouped with a product. To see the entire product splits forecasts, create a joined report that includes this report type and these report types. Forecasting Items as the primary object with Product Splits: Items with Products No Splits and Opportunity Product Splits as related objects Forecasting Items as the primary objects with Product Splits: Items with Product Splits and Opportunity Product Splits as a related object
Forecasting Quotas	Viewing data about individual or team quotas. We recommend including all the default fields in the report type. For example, you can include lookup fields, such as the full name of the owner. When running the report, you can filter by your name to see quotas that you created and their related accounts and owners.
Forecasting Quotas with Forecasting Items as a related object	Viewing quota attainment. For example, you can use Forecasting Quotas and Forecasting Items to create the custom report type. Then, when you create the report, include a team’s quotas and forecast revenue for closed forecasts, and create a formula field to show the attained quota percentage.
Forecasting Submission with Forecasting Items or Forecasting Submission Items as a related Object	Viewing submitted forecasts over time. For example, you can use Forecasting Items and Forecasting Submission to create a custom report type. Then, when you create a report, include a team’s forecast revenue for closed opportunities to compare what was submitted to what was closed. Creating this report also allows sales teams to review an extended history of their submissions, beyond what is available in the forecasts page.
Opportunities with Forecasting Source Record Judgments as a related object	Viewing opportunities with their amounts and their judgment value. For example, create a report sorted by opportunity owner that includes the Manager Judgment field, amount, and the forecast category to aggregate a rollup of amounts judged IN and OUT in a forecast. Including forecast judgments in reports works best if you apply judgments in either role-based forecast hierarchy or territory hierarchy forecast types, not both. If you use manager judgments in both role-based hierarchy and territory hierarchy forecast types, users other than Salesforce admins see judgments made in the role-based hierarchy only.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png) Note If you delete a forecast type, reports that use that forecast type don’t run.