---
schema_version: "1"
id: 31dafe328f17ce2873393eec14772b469c4035916caebfa2664a541f1fc11210
title: Tips for Working with Opportunity Reports
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_oppforesales_tips.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_oppforesales_tips.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 036e5f1764f8eb1e2f36882845d5c34069d74d4871b402af4641c584f8e2730a
description: Opportunity reports can include all opportunity fields plus some extra columns for more detail.
products:
  - Cross Cloud
release: "264"
---
# Tips for Working with Opportunity Reports

Opportunity reports can include all opportunity fields plus some extra columns for more detail.

- You can use the following columns to provide more detail:
    - Age—Age counts the number of days passed between opportunity open date and close date. On a given day, it's possible for opportunity A to have been closed for 0:00 - 23:59 hours (which appears as 0) and opportunity B to have been closed for 24:00 hours or more (which appears as 1).
    - Stage Duration—The number of days the opportunity was in the stage listed in the Stage column. You can run the Opportunity Stage Duration report to see how much time an opportunity spent at different stages.
    - Last Activity—The most recent due date of an activity on the opportunity record, including any opportunity event or closed task.
- Not all Opportunity Product fields are available in report filters. For example, the Product Family field is not available in Opportunity Product report filters because it is related to that object through the Pricebook Entry object. To make the Product Family field available in Opportunity Product report filters—for cross-sell or upsell reporting—create a custom formula field to store its contents and use that formula field in your filter. From the object management settings for opportunities, go to the fields area, then create a custom field of type Formula, making sure to use Text for your formula return type and `TEXT(PricebookEntry.Product2.Family)` for your formula.
- In Professional, Enterprise, Unlimited, Performance, and Developer edition organizations, the **Hierarchy** links let you browse report results based on the role or territory hierarchies.
- You can include the Primary Campaign Source field on all standard opportunity reports. This field is controlled by field-level security.
- Use the View filter to limit your opportunity report results. View options vary depending on your organization's Edition and setup.
    - My opportunities—Shows only your opportunities.
    - My team-selling opportunities—Shows opportunities for which you are on the opportunity team.
    - My team-selling and my opportunities—Shows your opportunities and opportunities for which you are on the opportunity team.
    - My team’s opportunities—Shows your opportunities and opportunities owned by all of your subordinates in the role hierarchy.
    - My team’s team-selling and their opportunities—For users who report to you in the role hierarchy, this shows opportunities that they own or for which they are on the opportunity team.
    - My territories—For organizations that use Enterprise Territory Management, this option shows opportunities that belong to the territories to which you are assigned.
    - My territories’ opportunities—For organizations that use Enterprise Territory Management, this option shows opportunities that belong to the territories to which you are assigned.
    - My territory team’s opportunities—For organizations that use Enterprise Territory Management, this option shows opportunities that belong to the territories to which you are assigned and their child territories.
    - All opportunities—Shows all opportunities that you can view.

#### See Also

- [Opportunity Reports](https://help.salesforce.com/s/articleView?id=analytics.reports_oppforesales.htm&release=264.0.0&type=5 "Opportunity reports provide information about your opportunities, including owners, accounts, stages, amounts, and more. The default settings show you the most commonly used information from each object, but you can customize a report to view other information, such as primary campaign source, forecast category, and synced quote.")
- [Opportunity Report Types](https://help.salesforce.com/s/articleView?id=analytics.reports_oppforesales_custom.htm&release=264.0.0&type=5 "Report types provide a report template that you can customize to capture the unique data you’re after without creating a report from scratch. Many of the opportunities custom report types include information from associated objects, such as products, partners, and quotes.")
- [Standard Opportunity Reports](https://help.salesforce.com/s/articleView?id=analytics.reports_oppforesales_standard.htm&release=264.0.0&type=5 "Standard opportunity reports help you report on your opportunity pipeline and history, opportunity sources, opportunity types, and more.")