Skip to main content
Hey, my fellow Salesforce users.  

 

I have seen iterations of this question in various forums but have yet to find a solution. So I thought I'd try with my specific example and see if by chance there is a solution that I've missed.

 

* We have Private Equity firms that we work with but they are not the contracting entity. We create Parent Accounts for each firm.  (e.g. L Catterton - http://www.lcatterton.com/)

 

* Each PE firm has several companies in their portfolio that we actually contract directly with.  Each of these companies are created as 'children' and tied back to the appropriate parent.  (e.g. Cholula - http://www.lcatterton.com/Brands.html#!/current)

 

WHAT I NEED:  One report that shows all opportunities (any stage) at all children accounts then tied to the parent company.

 

Here's the example that I created in Excel:

 

One opportunity report that includes opps for both parent and children accounts

 

Also, is there any type of report that would show the same information as when you click on "View Hierarchy" by the Account Name in the Account Object?

 

Thank you, Lynette - Tulsa, OK
4 Antworten
  1. 30. Aug. 2019, 20:14
    Hi Lynette,

     

    You can create a summary report on Child Account and Opportunities

     

    Hi Lynette, You can create a summary report on Child Account and Opportunities And then Summarise report by Parent Account field on Child account.

     

    And then Summarise report by Parent Account field on Child account.

     

    User-added image